This should be an easy one but my brain is sluggish today, so any help is appreciated.
I have 2 columns, one with names and other with age. the name column could have duplicates. If a name has a duplicate, I want to highlight oldest person. Is there are conditional formatting formula that we...
@Faseeh Thanks. Yes, the names will be different each time. I just made up the example to avoid sharing sensitive data. All I want to actually do is remove duplicates, retaining just one unique entry satisfying the A to D criteria and treating the name in E as duplicate irrespective of the word...
Here's an interesting question for you rockstars. its in 2 parts
1. I have a excel sheet with 6 columns. A, B, C, D, E and F.
All columns are text except F.
Column E contains the core phrase that I'm interesting in finding duplicates of.
A, B, C and D can be looked at as phrases that...
Thanks a lot for your help Kaushik. Unfortunately I cannot share the workbook. I'll see if can create a dummy workbook if your suggestions hit a roadblock. First let me try them out.
Thanks for your time!
Shyam
Thanks Kaushik. I'll try it out.
I should have been clearer. Apologies.
Yes, C6 has a drop down control through validation, which through various vlookup and other formula changes other values in the sheet (based on the selection). It is a dashboard which I want to set it to 12/7/2012 when...
I have about a 100 files in a folder (.xlsx) which all have the same 5 tabs in them. I need to do these things on all of them.
1. In Tab named 'Dates', there is a drop down in C6 which has to be set to 12/7/2012.
2. Hide Tab named 'Raw'.
3. Delete Tab named 'Old'
Is there Loop routine in...
Beautiful! I cleaned up the dates and the array formula works like a charm!
Good learning about not mixing up logical operators with Array formulas. Thanks Deb, Narayan and Hui!
I'm working on something that i need some help with.
I don't see an option to attach a sample Excel file, so here is a sample. Runs from A3 to A354 excluding the heading(heading on A2 and B2)
Week Start Volume
1/2/2006 477
1/9/2006 391
1/16/2006 303
1/23/2006 386
1/30/2006 595
2/6/2006...
i was looking for a ways in which we can link a website to an excel site and maintain a map of the inventory on it.
For example, if you look at http://www.amazon.com/kitchen-dining-small-appliances-cookware/b/ref=sa_menu_ki10?ie=UTF8&node=284507
is it possible to maintain a local excel...
Hi Excel Wizards,
Probably a easy one!
I have a situation such with 3 columns (Name, metric1, metric2) and the goal is to pick one row based on metric1 and metric2 for each of the names. There are multiple entries for each name. I've pasted a sample table below.
So for each name, I'd like...