• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Vlookup formula to look part of lookup value -Please Help

    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...
  2. S

    how to select the cells which have value less than certain number (let's say 100)

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

    PowePivot installment problem in excel 2010

    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...
  4. S

    Formatting number of columns based on value on other cell

    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.
Back
Top