Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting right info
I have a large list of stock and description and qty on sheet1, and i would
like to extract just stock with qty value 0 to sheet2, which i managed with =IF(Sheet1!$D$1:$D$200,Sheet1!$A$1:$A$24,""), however the distracted info is scatered across the sheet2 according to fields they been stored in sheet1. Is there a formula, which would help me to transfer necesary info to sheet2, as soon qty0 anywere on sheet1, but so the transfered info would go nicly one by one in column on sheet2 with no gaps. I hope you gus understand what i ma trying to say here :) thanks for help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
credit card accts. info ( APR & other acct. info. ) log | Charts and Charting in Excel | |||
Lookup info in one Column and then returning info in other columns | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |