Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function (i think)
Hi Guys, I think this is pretty basic but im not very good with lookups, ive
had a look thru prev posts but cant find this (prob because its so basic).. I am entering data in many rows and putting $ amounts in column F. I need to know when entering $ in Column F if that amount has been entered in that column anywhere above. Maybe it could highlight red or something?? any help would be fantastic.. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function (i think)
See http://www.contextures.com/xlCondFormat01.html
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Scott R" wrote in message ... Hi Guys, I think this is pretty basic but im not very good with lookups, ive had a look thru prev posts but cant find this (prob because its so basic).. I am entering data in many rows and putting $ amounts in column F. I need to know when entering $ in Column F if that amount has been entered in that column anywhere above. Maybe it could highlight red or something?? any help would be fantastic.. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function (i think)
Do you want to prevent a duplicate or just flag the duplicate?
See Chip Pearson's site on Duplicates. http://www.cpearson.com/excel/Duplicates.aspx for flagging http://www.cpearson.com/excel/NoDupEntry.aspx for preventing Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 15:22:00 -0800, Scott R wrote: Hi Guys, I think this is pretty basic but im not very good with lookups, ive had a look thru prev posts but cant find this (prob because its so basic).. I am entering data in many rows and putting $ amounts in column F. I need to know when entering $ in Column F if that amount has been entered in that column anywhere above. Maybe it could highlight red or something?? any help would be fantastic.. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function (i think)
OR ... you could go the other way, and *prevent* the duplicate entry in the
first place: http://www.cpearson.com/excel/NoDupEntry.aspx -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bob Phillips" wrote in message ... See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Scott R" wrote in message ... Hi Guys, I think this is pretty basic but im not very good with lookups, ive had a look thru prev posts but cant find this (prob because its so basic).. I am entering data in many rows and putting $ amounts in column F. I need to know when entering $ in Column F if that amount has been entered in that column anywhere above. Maybe it could highlight red or something?? any help would be fantastic.. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function (i think)
I needed it to flag and those websites worked. Thanks Guys! :)
"Gord Dibben" wrote: Do you want to prevent a duplicate or just flag the duplicate? See Chip Pearson's site on Duplicates. http://www.cpearson.com/excel/Duplicates.aspx for flagging http://www.cpearson.com/excel/NoDupEntry.aspx for preventing Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 15:22:00 -0800, Scott R wrote: Hi Guys, I think this is pretty basic but im not very good with lookups, ive had a look thru prev posts but cant find this (prob because its so basic).. I am entering data in many rows and putting $ amounts in column F. I need to know when entering $ in Column F if that amount has been entered in that column anywhere above. Maybe it could highlight red or something?? any help would be fantastic.. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function? | New Users to Excel | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Need Help on Lookup function | Excel Worksheet Functions | |||
Lookup function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |