| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data
My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there
is a value in column d. When attempting to sort the results from shortest to longest number of days, I lose the formula results due to a Ref error. How can I correct this problem? thanks, harley |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Data
Probably a typeo...........
a2 should be a5 =If(d5=0,0,a5-i5) Vaya con Dios, Chuck, CABGx3 "Harley" wrote: My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there is a value in column d. When attempting to sort the results from shortest to longest number of days, I lose the formula results due to a Ref error. How can I correct this problem? thanks, harley |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Data
if a2 is something like today's date, make it $a$2 so it doesn't move when
you sort. "Harley" wrote: My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there is a value in column d. When attempting to sort the results from shortest to longest number of days, I lose the formula results due to a Ref error. How can I correct this problem? thanks, harley |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Data
That got it!
thanks. "dlw" wrote: if a2 is something like today's date, make it $a$2 so it doesn't move when you sort. "Harley" wrote: My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there is a value in column d. When attempting to sort the results from shortest to longest number of days, I lose the formula results due to a Ref error. How can I correct this problem? thanks, harley |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data | Excel Worksheet Functions | |||
| SORTING DATA | Excel Worksheet Functions | |||
| Sorting data to match existing data | Excel Discussion (Misc queries) | |||
| Sorting Data | Excel Discussion (Misc queries) | |||
| colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Linear Mode
