excel query

Can anyone tell me how yo convert Index numbering to level format in excel ? I have one column of bill of materials which consists Index numbering like 1,1.1,1.2....1.1.1,1.1.2 And i need to segregate index numbering level wise like level 1 , 2... Ect.

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......

How to Pull data One file to both file ???? I try to Pull data "Master" File To "Local" & "Export" File .......... I don't Know ???? How to possible .......Pleased send us Formula in excel..

Condition-1 Match List-1 & List -2 Number & Show result in list-2 "item" Cells........

How Hide Row According value is Zero on Pivot tables ??? Condition is zero value to hide table Entry in pivot tables.

# How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????

Hi all, I am now getting annoyed. I had a query in another workbook, and I copied the query to a new workbook, but the table the query is linked too does not exist in the new work book. I deleted the query and created a new one, but when I put in the current.workbook formula, it brings up the...

Subject: Automate the reorganization of two columns based on the unique identifier "Name", and a corresponding "Reports-to" column. Version: Office 365 OS: Windows 10 Urgency: Low Examples Included So I have a project that I am trying to work on in my free time (but could use some help with) to...

I am trying to get a macro to run when a cell is selected. After a parameter is entered into the cell above it for a Query. My problem is the On_Refresh routine runs before the refresh is finished..I have turned off the "Enable backgorund refresh" in the properties of the query. I have tried...

Is there any way (like countifs function) to count number of blanks in a column provided a number is present in the previous column, Ex. In the ninth row, the data for 2011 is blank but the previous column some data is present, is there any way I can count such instances using a fuction...

I have two workbooks. Workbook A contains four spreadsheets (of various customer data). Workbook B uses formulas and queries to import the data from Workbook A. I have to email, or upload both of these workbooks to a customer so they can continue to update the data in Workbook A, and...

Hi, I have an application using multiple queries. I left this application several months ago now I return to continue the development. The problem I have is that some queries I tried before are still somewhere in excel, now I am trying to put some order in the name of the queries but excel keeps...

Hi, I have a database of 338 members, all the information is entered in an excel sheet (named: Main) column wise, lets suppose the data for the first member is in the row 2 (first row is used for column headers) i.e.: A1 contains Serial (Here 1) B1 contains First Name (Here John) C1 contains...