| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup or IF function ?
This is what im trying to do, I have the data sorted I just need to pasted to
a summary sheet. If a Cell in Column A is Blank Paste Cell J From the same row to make a summary page. ie Date A J 1 500 2 500 3 500 4 500 Blank (500) Paste this one 6 600 Blank (600) Paste this one 8 700 ie Summary 500 600 ect.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup or IF function ?
You could apply an Autofilter to your data. In column A, click on the
dropdown box and choose "Blanks", then copy the visible rows to your new sheet. Check it out here http://www.rondebruin.nl/copy5.htm HTH, JP On Nov 15, 7:00 am, Terry wrote: This is what im trying to do, I have the data sorted I just need to pasted to a summary sheet. If a Cell in Column A is Blank Paste Cell J From the same row to make a summary page. ie Date A J 1 500 2 500 3 500 4 500 Blank (500) Paste this one 6 600 Blank (600) Paste this one 8 700 ie Summary 500 600 ect.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup or IF function ?
Thanks JP this works for one part of what I am doing. One problem is when I
filter the sums of each amount disappears. Is there a way i can filter a column to show only formulas spefically (=subtotal) "JP" wrote: You could apply an Autofilter to your data. In column A, click on the dropdown box and choose "Blanks", then copy the visible rows to your new sheet. Check it out here http://www.rondebruin.nl/copy5.htm HTH, JP On Nov 15, 7:00 am, Terry wrote: This is what im trying to do, I have the data sorted I just need to pasted to a summary sheet. If a Cell in Column A is Blank Paste Cell J From the same row to make a summary page. ie Date A J 1 500 2 500 3 500 4 500 Blank (500) Paste this one 6 600 Blank (600) Paste this one 8 700 ie Summary 500 600 ect.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Linear Mode
