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

    Splitting monthly budget figures to daily figures

    Need to calculate percentage of Qty v/s total qty of June 2022 See the column "O" & "P" In "H3" =SUM($L$3*O3)/100 IN "I3" =SUM($M$3*P3)/100
  2. A

    execute command to save manual work

    I don't understanding what you required in "A10" If you required result 15 in "A10" then answer in your question =sum(A1:A5)
  3. A

    sum formula with automatic action

    Firstly restructure sheet see attachment Go to formula tab > Name manager > new > Enter name as data1 > refers to give range =Sheet1!$D:$D same for other table. =sum(data1) in another column.
  4. A

    comparing two excel sheets.

    One way trying. For reconcile any one field common required. Hence extract number from description & narration column from both sheet. With formula =IF(SUM(LEN(D2)-LEN(SUBSTITUTE(D2, {"0","1","2","3","4","5","6","7","8","9"}, "")))>0, SUMPRODUCT(MID(0&D2...
  5. A

    Total Experience

    In "B11" =MIN(B6:B10) In "C11" =MAX(C6:C10) IN "D11" =DATEDIF(B11,C11,"Y")&"." & DATEDIF(B11,C11,"YM")
  6. A

    how to write a transpose formula

    Select data "B2" to "F2" press ctrl "C" (for copy) Go to "B5" & right click > paste special > right mark on "Transpose" > press "ok"
  7. A

    EXCEL SHEET FOR HOTEL ISSUES

    Refer attach file. You can do with index match formula. Also created hyperlink with main sheet & individual sheet. You can directly jump to respective sheet if you click on room number in main sheet, from individual sheet click to return to main sheet. Hope this want you.
  8. A

    Long row formula

    Instead of each row why not using summary for single employee of particular day. Look attach file summary sheet.
  9. A

    Lookup data

    In "C12" =SUMPRODUCT((Sheet1!$B$3:$B$10)*(Sheet1!$C$3:$C$10=Sheet2!$A12)*(MONTH(Sheet1!$A$3:$A$10)=MONTH(Sheet2!C$2&0)))
  10. A

    AOP Vs Actuals and Variance analysis

    Refer attach file. In "Monthly Expenses" sheet in "G" column calculate achievement percentage. Look at summary sheet in this sheet we summarizes Data with using formula index match.
  11. A

    Pivot Table

    If you attach sample file with required result its more helpful.
  12. A

    Excel formula for Pivot

    Any new data add in sheet1 After "Refresh all" in sheet3 automatically add those new data. Try it with new data.
  13. A

    Match Specific Text and lookup value for that

    In another way.. Suppose your data in in "A" is Description & "B" is Rate. In "D2" criteria mentioned *Apple iphone 5s* & "D3" *Apple iphone 6s* (Mark * before & after in criteria) In "E2" =IFERROR(INDEX($B$2:$B$3,MATCH($D2,$A$2:$A$3,0)),"") Array formula hence shift+ctrl+enter
  14. A

    Excel formula for Pivot

    Firstly add data in sheet1. Go to sheet3 > options > Refresh > Refresh All
  15. A

    Excel formula for Pivot

    In sheet1 insert table range. Insert Pivot table. If you add new data in sheet1 > After that go to Pivot > go to option > click refresh all new data automatically insert in pivot. Look sheet3
  16. A

    data validation list - Select all criteria.

    One way you can do. In sheet "2W-NDCC" column "B" Formula : =IF('Dashboard NDCC'!$B$1='2W-NDCC'!$A4,'Dashboard NDCC'!$D$1&" "&'Dashboard NDCC'!$D$2,"") Copy down. In sheet "Dashboard NDCC" in "D2" add datavalidation formula in "A5" =IF(COUNTIFS('2W-NDCC'!$A$1:$A$5000,'Dashboard...
  17. A

    Using OLAP Tools for Pivot Table...

    plz share file
  18. A

    Changing datatype in PowerPivot column

    Kindly attach sample workbook with before data & after data.
  19. A

    How to import filelist from folder to excel

    Watch below link.
  20. A

    Date Formating

    Date format always in english (u.s.)
  21. A

    Need to make multiple subsets/subtotal of total values

    what is a criteria? how come values 200 - 100 explain detail.
  22. A

    vLOOKUP and IF or what?

    You can also try with =INDEX(Maps!L:L,MATCH(COGS!A70,Maps!G:G,0)) copy paste down
  23. A

    Keep spacing between pivot tables

    refer post #4 attach file.
  24. A

    Keep spacing between pivot tables

    Refer my attach file.
  25. A

    Keep spacing between pivot tables

    Dear Gman, if you add data in sheet1,2,3 & in sheet122 in option tab >click on "Refresh all, auto update in pivot.
Back
Top