Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell called "CURBAL" I want to get the data of the cell on the LEFT
of that one. My formula now is =IF($E13=0,"Delete Me",F13) The location of E13 changes everytime (also of course CURBAL) so I have to manually change it. But as I said I know the data its ALWAYS on the left of the cell called CURBAL Any idea? ps The row where CURBAL is it's always the same one. So maybe a combination of "sumif" and "if"... is that possible? |