You are here:
[Overview] Having hands-on experience with Excel, I can able to answer questions which is related to Conditional Formatting, Goal Seek, Scenarios, Subtotal, Validation, Pivot Table, Shared Workbook, Excel Sheet / Workbook Protection, Excel Settings, Excel Shortcuts and the Two Major & Massive Key Areas of Excel (i.e.) Worksheet Functions and Excel VBA (Macro).
Vast Experience
Ms-Office, Oracle, Foxpro, C, COBOL etc.,
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| NITIN | 05/16/12 | 10 | 10 | 10 | Absolutely to my requirement. Thanks a lot ..... |
| Eric | 05/14/12 | 10 | 10 | 10 | |
| Eric | 05/14/12 | 10 | 10 | 10 | Wow that is amazing, thank you so ..... |
| Chris | 05/07/12 | 10 | 10 | 10 | got the answer I needed. Thanks for ..... |
| pitambar rout | 05/07/12 | 10 | 10 | 10 | i am happy say that as per ..... |
Hi Sonja, I have created a Sample file which is available in the below link; click to download:- <a href="https://doc-0c-3s-docs.googleusercontent.com/docs/securesc/ha0ro937gcuc7l7deffksulhg5h7mbp1/5addiegf6lbjqcnff2nsdt81bmf572pn/1337839200000/08849022783486111145/*/0B2TMxNyEPQ2rM29PZE5XS1lBMm8?e=download">https://doc-0c-3s-docs
Irum, I assume that Sheet2 is having the Master Data and your desired result is in Sheet1. If yes, please copy and paste the following formula in B2 cell and drag it to the rest of the columns and rows
Hi Irum, Thanks for sending your question on my way and I request you to provide some more details for my better understanding. Details Required 1) 10 Rows of your Data which should cover your
Hi Nitin, Thanks for your wishes! As per your screenshot image the source data starts from 7th Row and use any of the below formula in the C5 cell. I am giving below two different approaches for
Hi Eric, Thanks for your feedback. Could you please let me know whether you have the OEM and Compatible list separately in different sheets? if so then the executed macro should skip the items available
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.