| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy rows if greater than zero
I have a sheet where the user selects options up to 12 times, this
automatically generates a part number for each position. On another sheet I use a list of possible part numbers with COUNTIF functions in adjacent cells. This works fine, it puts "0" in every adjacent cell then counts how many times each part number is chosen. (about 40 part numbers) What I want to do now is pull out any part numbers that don't have a zero next to them and put them all in another list on another sheet with the quantities next to them?Part nos. A77:A128 Quantity (COUNTIF) B77:B128 Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count filtered rows based on condition greater than forty | Excel Worksheet Functions | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| sort data rows "greater than or equal" criteria in another cell | Excel Worksheet Functions | |||
| Charting when number of rows are greater than 65536 | Charts and Charting in Excel | |||
| Worksheet that only shows rows with quantity greater than zero | Excel Discussion (Misc queries) | |||
Threaded Mode
