# excel query

1. ### Convert Index numbering to level number

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.
2. ### We Need Only TEXT Contain, How to possible in Excel Formula ????

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......
3. ### How to Pull data One file to both file ????

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..
4. ### How to Possible match "List-1" & "List-2" Both number match & show Result "List-2" in item cell ???

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

6. ### How Hide Row According value is Zero on Pivot tables ???

How Hide Row According value is Zero on Pivot tables ??? Condition is zero value to hide table Entry in pivot tables.
7. ### How to sum with unique Invoice Number wise ?????

# 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 !!!
8. ### Query: How to count same party with unique Invoice numbers....

like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????
9. ### cannot unlink worksheet from another workbook

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...
10. ### "Name" and "Reports-to" Sequence Project

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...
11. ### Waiting for Refresh

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...
12. ### Question on Count

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...
13. ### Keep workbooks linked when the path changes XL2003

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...
14. ### query name location

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...
15. ### Retrieving data from one Excel sheet to another (More like amkig Access like queries in excel)

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back