row wise query

G

Gerald

dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid 1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks
 
O

Otto Moehrbach

Gerald
You must understand that no one who is reading what you wrote has any
idea about what you mean by the terms you use. Please post back and explain
what you have, what you want to have, and how you want to get from one to
the other, and do it all in plain common words. For instance, explain:
"empit 1"
"displayed as addition"
"displayed as deletion"
HTH Otto
 
J

JLatham

How did things get to be red, yellow or green in the first place? And by
"highlighted" do you mean the font/text is colored or the cell background is
colored?

Keep in mind that formulas in cells can't determine the color of a cell's
font (text) or background. A solution using colors is going to take VBA
coding.
 
G

Gerald

apologies for not been clear, allow me to explain again with below e.g.

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not have
00010, it should display in column 3 as addition

hope I was clear now

Thanks for looking into my query
 
O

Otto Moehrbach

Gerald
What does "it should display in column 3 as addition" mean? Exactly
what do you want to see in column 3? And what is the rational that would
drive column 3 to "display as addition"? HTH Otto
 
G

Gerald

below is a test example

column1 column2 column3
list 1 00010
list 1 00010
list2 00011

I need a check on these 3 rows and if from above example list2 does not have
00010, it should display in column 3 as addition
 
O

Otto Moehrbach

Gerald
We are not connecting. To "display as addition" means nothing to me.
Don't say that column 3 "should display as addition". Tell me exactly what
you want to see in column 3 and also tell me why column 3 should show that.
In other words, what is the logic behind what you want to see in column 3?
HTH Otto
 
G

George Gee

I'm pretty sure no-one here has a clue what you are trying to achieve,
so try this in cell C1

=IF(A1:A3<>00010,"as addition","")


George Gee
 
R

Roger Govier

Hi George

Not sure I am going to fair any better than you at interpreting Gerald's
requirement, but here goes

Does List1, List 2 List 3 refer to named ranges?
If so, then maybe in C1
=IF(COUNTIF(INDIRECT(A1),B1),"","as addition")
 
G

George Gee

Hi Roger

Maybe one of us is on the right lines, not sure,
but I think we're only scratching the surface here.
We've not yet addressed the colour comparisons
in the original post!

Also I would dearly like to know what "empid" means,
sounds fascinating.

George Gee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top