| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep value if formula has no data
I have a worksheet that automatically updates everyday and works some
calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
Post your formula.
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "NTaylor" wrote in message ... I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
Nikki, what you could do is copy the entire sheet (click the button above row
1 and to the left of column A) then right click and copy. Go to a new sheet, click on cell A1, right click and Paste Special "Values". If you want it to look the same as you original sheet, right click again in the same place and Paste Special "Formats". "NTaylor" wrote: I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
I am sorry but I don't know what that means.
-- Nicki Taylor "RagDyeR" wrote: Post your formula. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "NTaylor" wrote in message ... I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
Copy some of the formulas that are returning 0 in your sheet and paste them
in a message (post) in this thread, just like you did when you told me you didn't understand. That way, folks here can see exactly what your formulas are doing, and can suggest various solutions to your problem. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "NTaylor" wrote in message ... I am sorry but I don't know what that means. -- Nicki Taylor "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "NTaylor" wrote in message ... I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
I know how to do that, but I was hoping I could have it just keep the values
if there wasn't data b/c I am importing it on a daily basis and don't want to go through every sheet to copy and paste every time. Thanks though! -- Nicki Taylor "JR" wrote: Nikki, what you could do is copy the entire sheet (click the button above row 1 and to the left of column A) then right click and copy. Go to a new sheet, click on cell A1, right click and Paste Special "Values". If you want it to look the same as you original sheet, right click again in the same place and Paste Special "Formats". "NTaylor" wrote: I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
Oh.. Like in one cell:
=SUMIF(ImportData!A:A, IDEA!A1412, ImportData!H:H) I have a whole bunch of these set up in my sheet. I import the data once a day for our daily sales. It automatically fills in the cells with my import. But then some of that data expires, so I don't report on it any more. It is no big thing to have to copy and paste special to values... it would be nice if it could do the formula, but if the data wasn't there, just keep the last value it had set. Does that make sense? -- Nicki Taylor "RagDyer" wrote: Copy some of the formulas that are returning 0 in your sheet and paste them in a message (post) in this thread, just like you did when you told me you didn't understand. That way, folks here can see exactly what your formulas are doing, and can suggest various solutions to your problem. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "NTaylor" wrote in message ... I am sorry but I don't know what that means. -- Nicki Taylor "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "NTaylor" wrote in message ... I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep value if formula has no data
What type of data is in ColumnA & H?
Do you import into both columns? And if you do, I don't understand exactly what data you're trying to retain. Doesn't the newly imported data overwrite the "old" data? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "NTaylor" wrote in message ... Oh.. Like in one cell: =SUMIF(ImportData!A:A, IDEA!A1412, ImportData!H:H) I have a whole bunch of these set up in my sheet. I import the data once a day for our daily sales. It automatically fills in the cells with my import. But then some of that data expires, so I don't report on it any more. It is no big thing to have to copy and paste special to values... it would be nice if it could do the formula, but if the data wasn't there, just keep the last value it had set. Does that make sense? -- Nicki Taylor "RagDyer" wrote: Copy some of the formulas that are returning 0 in your sheet and paste them in a message (post) in this thread, just like you did when you told me you didn't understand. That way, folks here can see exactly what your formulas are doing, and can suggest various solutions to your problem. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "NTaylor" wrote in message ... I am sorry but I don't know what that means. -- Nicki Taylor "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "NTaylor" wrote in message ... I have a worksheet that automatically updates everyday and works some calculations for me. How can I get the formula sheet to keep the value from the previous day if there is no data today. Because now it is filling in all my cells with zeros. Thanks -- Nicki Taylor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Linest function: data not being selected in formula | Excel Worksheet Functions | |||
| Formula retrieves wrong data | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Linear Mode
