Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It's likely that the numbers in Column E are being recognized as text.
Try the following... 1) Select an empty cell 2) Edit Copy 3) Select Column E 4) Edit Paste Special Add Ok Does this help? In article . com, wrote: okay i'm not getting an error message anymore, but it's not bringing up the right information. the formula is bringing up values from "d" with zeros in "e"; it misses values from d with positive values in "e" and finally, when you delete one from the top of the list, the rest of the cloumn should adjust, but it isn't... any clues? if not it's okay, it's not that much manual work, the original formula is a big help for me though. thanks again. jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match formula that pulls unique values from another column? | Excel Discussion (Misc queries) | |||
What is the formula for adding a number of days to an existing dat | Excel Worksheet Functions | |||
insert a new cell into an existing formula | Excel Discussion (Misc queries) | |||
Modifying an Existing Formula | Excel Worksheet Functions |