Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i recreate a list without errors
I receive a huge list of data results from a supplier weekly with a varying
amount of rows of data. In the first row there are all numbers, in the second row the are numbers with chunks of about 30 rows every now and agin with #N/A in them, is there a way i can get excel to plot the 2nd row in column three with the #N/A's missing and the gaps cut out so it is still a continuous list albeit several rows shorter? i think countif may be able to do this or a macro maybe? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I force Excel to recreate links it lost in conversion. | Excel Discussion (Misc queries) | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Can excel read my old lotus 123 files or will I have to recreate? | Excel Discussion (Misc queries) | |||
Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |