(Msg. 1) Posted: Wed Sep 10, 2008 12:53 pm
Post subject: Formula result in multiple cells Archived from groups: microsoft>public>excel>misc (more info?)
I have a spreadsheet with multiple columns of data, one column is a reference
number, another is a value. I want to write a formula that first looks at the
reference number and if there is more than one entry for the same reference
number, I want it to look at the values and if the sum of the values is nil,
I want it to identify all of the entries for that reference number. eg cells
b3 & b4 have same reference number and the sum of g3 & g4 is nil, I want an
indicator in cell L3 & L4.
(Msg. 2) Posted: Wed Sep 10, 2008 1:22 pm
Post subject: RE: Formula result in multiple cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Put this in L3 (press CTRL-SHIFT-ENTER together instead of ENTER)
> I have a spreadsheet with multiple columns of data, one column is a reference
> number, another is a value. I want to write a formula that first looks at the
> reference number and if there is more than one entry for the same reference
> number, I want it to look at the values and if the sum of the values is nil,
> I want it to identify all of the entries for that reference number. eg cells
> b3 & b4 have same reference number and the sum of g3 & g4 is nil, I want an
> indicator in cell L3 & L4.
>
> Thanks in advance
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office