 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006row wise query
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 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 > dears, > [quoted text clipped - 12 lines] > > thanks 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 > Gerald > You must understand that no one who is reading what you wrote has any [quoted text clipped - 21 lines] > > > > thanks 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 > apologies for not been clear, allow me to explain again with below e.g. > [quoted text clipped - 42 lines] >> > >> > thanks 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. > dears, > [quoted text clipped - 10 lines] > > thanks 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 > 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 [quoted text clipped - 18 lines] > > > > thanks 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 > below is a test example > [quoted text clipped - 35 lines] >> > >> > thanks 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 > below is a test example > [quoted text clipped - 35 lines] >> > >> > thanks 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")  SignatureRegards Roger Govier > I'm pretty sure no-one here has a clue what you are trying to achieve, > so try this in cell C1 [quoted text clipped - 45 lines] >>> > >>> > thanks 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 > Hi George > [quoted text clipped - 54 lines] >>>> > >>>> > thanks Hi George > Also I would dearly like to know what "empid" means, My guess is Employee ID? SignatureRegards Roger Govier > Hi Roger > [quoted text clipped - 67 lines] >>>>> > >>>>> > thanks Hi Roger Ah, not very exciting after all......! George Gee > Hi George >> Also I would dearly like to know what "empid" means, > > My guess is Employee ID? > Regards > Roger Govier |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.