• 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. M

    Two categories in Pivot table

    Thanks Hui but not getting yet See below:- I need three column as 1 st Row labels which is 6020 ( part number ) then second column as REVOLUTION RANGE 16W BAY LAPTOP TRO ( part name ) and third is amount column $ 4244.04 Row Labels Sum of Revenue 6020 4244.04 REVOLUTION RANGE 16W BAY...
  2. M

    Conversion

    Hey Try following =INT(A1*3600)&"Sec "&INT(A2*60)&" Sec "&MOD(A3,60)&" Sec" A1= cell for Hours in your case 23hours A2= cell for Min in your case 23 min A3= cell for sec in your case 3 sec Try answer will be 86400Sec 1380 Sec 3 Sec I hope it helps
  3. M

    Two categories in Pivot table

    How can we put two categories in Pivot table? I want product name and part number with sale s amount.(Not only one of Product name and number) I can see only one of two ( Product name and part number )are in one row with Sales amount in normal pivot table formatting. is there any way...
Back
Top