Search results

Hello All, I just wanted to know the formula for the below query. Start dates: 02/17/2023 09:15:26 02/23/2023 15:15:00 02/23/2023 14:20:25 End date: 02/24/2023 16:10:23 02/23/2023 16:30:02 02/24/2023 10:25:03 Results will be : No of hours taken between start date and end date (sample answer...

Hello, I have a query with regards to, how to find the unique words in excel and form the list of unique words in separate sheet... what formula needs to used or macro or vba...please help on this issue... Data: From A1 to AZ5000 cells have words... I need the unique words should be in...

I have 6 Sheets of data in one workbook... and I want to get all the 6 sheets of data in one sheet in other workbook file.. Please advise the formula or vbscript or macros

Hi, I have a query with regards to Count the number of letters in a cell I can use =len() but the answer is other cell what I should I have to do, I want to get the answer in same cell For eg: A1= Never if we put the formula in B1 =len(A1) it gives 5 but the answer in B1 Cell --> No...

Hi, I have a query in the pivot table... How to get the blank cell in the pivot table. i used the formula =IF(ISERROR(VLOOKUP(Data!C2,Data!$C$2:$C$30,1,0)),"",VLOOKUP(Data!C2,Data!$C$2:$C$30,1,0)) Data: A1: Company Name, B1---> Date, c1-----> Gold, D1---->Silver & E1----&#62...

Hello, I have a query… How to Copy multiple sheet data to one sheet which has different customer names that to date wise. This has having same headings for multiple sheets... (Sheets I have 5) --- Based on this I have to create a pivot chart and pivot table on daily basis… Sheet 1 – Headings...

Hello, I have a query with regards to Counts, where i am working on the productivity sheet.. In Sheet one has -- No. 1 2 3 4 5 6 7 Request: 45666 208956 201212 206878 207595 204568 203225 Date: 1-Dec-12 1-Dec-12 1-Dec-12...