Posted: 11/30/2016 12:13:51 PM EDT
|
Got it squared away with help from ARFCom. Thanks y'all.
I need help with a formula to check to see if an entry in "column A of tab 2" is in "column A of tab 1" and if not highlight the cell red of the unique value in tab 2. What's the best way of doing this?/ thanks in advance. For some reason I'm having a complete brain fart and am a n00b when it comes to Excel. 
|
|
Quoted: You're looking for conditional formatting. Haven't done that in a while and have to look up details, but that's your starting point. Conditional Formatting --> Highlight cell rules. If you don't see the ones you need, go to more rules. If needed, you can create a new rule in Conditional Formatting too. |
|
Quoted:
Conditional Formatting --> Highlight cell rules. If you don't see the ones you need, go to more rules. If needed, you can create a new rule in Conditional Formatting too. Quoted:
Quoted:
You're looking for conditional formatting. Haven't done that in a while and have to look up details, but that's your starting point. Conditional Formatting --> Highlight cell rules. If you don't see the ones you need, go to more rules. If needed, you can create a new rule in Conditional Formatting too. Duplicate values only do the ones within the same column. Here's the quick 'n dirty of the spreadsheet... I'm doing an inventory count on Tab1 of all the items that I entered into Tab2. Problem is, there's stuff that we scanned which is not in the inventory list in Tab1. I'm trying to see what items in Tab2 are not in the tab1 list. Know what I mean?? I'm not proficient enough with Excel to write a formula that would search and highlight those items in tab2. |
|
Quoted:
Duplicate values only do the ones within the same column. Here's the quick 'n dirty of the spreadsheet... I'm doing an inventory count on Tab1 of all the items that I entered into Tab2. Problem is, there's stuff that we scanned which is not in the inventory list in Tab1. I'm trying to see what items in Tab2 are not in the tab1 list. Know what I mean?? I'm not proficient enough with Excel to write a formula that would search and highlight those items in tab2. Quoted:
Quoted:
Quoted:
You're looking for conditional formatting. Haven't done that in a while and have to look up details, but that's your starting point. Conditional Formatting --> Highlight cell rules. If you don't see the ones you need, go to more rules. If needed, you can create a new rule in Conditional Formatting too. Duplicate values only do the ones within the same column. Here's the quick 'n dirty of the spreadsheet... I'm doing an inventory count on Tab1 of all the items that I entered into Tab2. Problem is, there's stuff that we scanned which is not in the inventory list in Tab1. I'm trying to see what items in Tab2 are not in the tab1 list. Know what I mean?? I'm not proficient enough with Excel to write a formula that would search and highlight those items in tab2. Vlookup the tab 2 items to their matching key then conditional formatting if the two are not equal. |
|
Quoted:
I need help with a formula to check to see if an entry in "column A of tab 2" is in "column A of tab 1" and if not highlight the cell red of the unique value in tab 2. What's the best way of doing this?/ thanks in advance. For some reason I'm having a complete brain fart. Couple ways to do this - Index/Matching or a simple VLOOKUP - which one you use depends if you need to lookup values both horizontally and vertically or not. We'll assume you just need to do a vertical lookup:
You can then apply conditional formatting to column B to highlight any cells containing the word "Missing" or values that aren't equal. |
| Depending on how often you need to do this and/or how many searches there are in each one. Might not hurt to look at creating a macro for it. I found it fun to learn how and to be able to punch a button and bam, done. First one I wrote was a massive wall of text, pushed the button and chug chug chug, crashed the computer over half the time. Refined it bit by bit, each time increasing speed and reliability while reducing the number of lines. In the end, just a couple of little lines and it was a punch the button and results popped up. https://www.google.com/search?q=excel+script+book&ie=utf-8&oe=utf-8#safe=off&q=excel+macros+book+pdf |
|
Quoted:
Couple ways to do this - Index/Matching or a simple VLOOKUP - which one you use depends if you need to lookup values both horizontally and vertically or not. We'll assume you just need to do a vertical lookup: Column A (Tab 1) Column B (Formula Tab 1)______________ ___________________________________ Beans =IFERROR(VLOOKUP(A:A,Tab_2_$A:$B,2,FALSE),"Missing") You can then apply conditional formatting to column B to highlight any cells containing the word "Missing" or values that aren't equal. Quoted:
Quoted:
I need help with a formula to check to see if an entry in "column A of tab 2" is in "column A of tab 1" and if not highlight the cell red of the unique value in tab 2. What's the best way of doing this?/ thanks in advance. For some reason I'm having a complete brain fart. Couple ways to do this - Index/Matching or a simple VLOOKUP - which one you use depends if you need to lookup values both horizontally and vertically or not. We'll assume you just need to do a vertical lookup: Column A (Tab 1) Column B (Formula Tab 1)______________ ___________________________________ Beans =IFERROR(VLOOKUP(A:A,Tab_2_$A:$B,2,FALSE),"Missing") You can then apply conditional formatting to column B to highlight any cells containing the word "Missing" or values that aren't equal. That worked great. Thanks. |
|
Glad you got help and beside the point, but it always bugs me when people claim to be "proficient in Excel" and then I ask them something around pivot tables or writing if/then/else logic and their eyes glaze over.
No, you dont have to be a VBA programmer but you should at least know what most of the ribbon buttons do if you claim to be proficient. 
|
|
Quoted:
Glad you got help and beside the point, but it always bugs me when people claim to be "proficient in Excel" and then I ask them something around pivot tables or writing if/then/else logic and their eyes glaze over. No, you dont have to be a VBA programmer but you should at least know what most of the ribbon buttons do if you claim to be proficient. Is that any worse than people that are too proficient in Excel and use it for things that a database should be doing? |
|
Quoted: Vlookup the tab 2 items to their matching key then conditional formatting if the two are not equal. Quoted: Quoted: Quoted: Quoted: You're looking for conditional formatting. Haven't done that in a while and have to look up details, but that's your starting point. Conditional Formatting --> Highlight cell rules. If you don't see the ones you need, go to more rules. If needed, you can create a new rule in Conditional Formatting too. Duplicate values only do the ones within the same column. Here's the quick 'n dirty of the spreadsheet... I'm doing an inventory count on Tab1 of all the items that I entered into Tab2. Problem is, there's stuff that we scanned which is not in the inventory list in Tab1. I'm trying to see what items in Tab2 are not in the tab1 list. Know what I mean?? I'm not proficient enough with Excel to write a formula that would search and highlight those items in tab2. Vlookup the tab 2 items to their matching key then conditional formatting if the two are not equal. Forgot about good ole Vlookup. |