Search results

Thank you very much for your explanation. I believe I might able to use lookup & search functions right way in future. I really appreciate. Thanking you, Sam

If you have time, could you please briefly explain formula & sub formula (formula forensics) of the above solution?

Shirvallabha Ninja, Wow! It's awesome. Thank you very much. Sam

Hi! I just uploaded the sample file. Thanking you, Sam

Good Morning, I reallly need vlookup (or other formula) help. I have following Table Array: AB 12 ABTS 19 DL 30 NL 15 XL 7 by using above table array, I want follow : Lookup Values What I want AB Dress 12 DL Pant 30 Shirt XL 7 Trouser ABTS Line 19 Socks NL Straight 15 Shoe AB 12 I would be...

John, Thank you for your suggestion

Thank you very much. Is there a way to do it without any VBA?

Good Morning Geniuses, How to select (not highlight) the cells which have value less than certain number (let's say 100)? Thanking you, Samtheman

Good Afternoon, I have excel 2010 with powerpivot installed. It was working fine till I installed home and student office 2013. I know that Microsoft doesn’t allow you to install powerpivot in home and student version of excel 2013. However, after installing excel 2013, I lost the powerpivot...

Amazing! Thank you very much. Slight change to your formula: =COLUMN()<=$H$1 This will help to format all the rows in the column. Your formulae will format the 1st row of the column only. Great! Thank you again.

I want to format no. of columns (via conditional formatting) based on the value of other cell. Eg:if cell H1=1, Format (let's say, with yellow background) Column A only; if H1=2, format Columns A & B;if H1=3, format Column A,B & C; if H1=4, Format Columns A,B,C & D and so on.