#excel #comparison

  1. K

    @HOW TO GET AUTO SERIAL NUMBERING with Condition , If Tracking "TO" and set Auto Serial Numbering

    • krunal123
    • Thread
    • #condition formatting #database #pivottable#vba #excel #comparison #excel #pivot #excel query #excel question #excelexport #filter #filterwithmultiplecriteria #formulahelp #if #if #match #index #pivot table#fiilter
    • Replies: 1
    • Forum: Excel Questions
  2. K

    How to Get Period-wise Stock

    @ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)
    • krunal123
    • Thread
    • #combination #conditional formatting #excel #comparison #excel #expert #excel #formula #confused #excel #minimum #index #excel #pivot #excelproblem #match #if condition #inventory #inventoryreporting #powepivot #powerquery #reference #sumifs exce formula excel formula array pivot table stock balnce
    • Replies: 7
    • Forum: Excel Questions
  3. K

    Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result

    how to Get Stock Balance After check " CATAGORY NAME " WITH "PRODUCT LIST" and show result - I was try but i was failed matching Product list with Category Kindly Need formula this Query K3 =SUMIF(A:A,I3,C:C) L3 =SUMIF(E:E,I3,G:G) M3 =K3-L3
    • krunal123
    • Thread
    • #database #pivottable#vba #excel #comparison #excel #expert #excel #formula #confused #excel #minimum #index #excel #pivot #excel match #formatting #datalabels #if #match #index exce formula
    • Replies: 3
    • Forum: Excel Questions
  4. K

    Getpivotdata using "SUMIFS" FORMULA for Stock management.

    =GETPIVOTDATA(SUMIFS(B4:B5,A4,"")-SUMIFS(C4:C5,A4,"")) I was trying Get data from pivot table, kindly Help to correction Formula... i was trying (PURCHESH NET WT-SALE NET WT) and getting Result... Get pivot data using "SUMIFS" FORMULA for Stock management. HELP ...
    • krunal123
    • Thread
    • #excel #comparison #excel #formula #confused #excel #vba #checkin/out #inventoryreporting #pivot table#fiilter #pivot tables #tables #power query #question #sumifs pivot and power query
    • Replies: 2
    • Forum: Excel Questions
  5. K

    Get Data "20 ft" OR "40 ft" After Select "PARTY LIST" Drop-down List

    • krunal123
    • Thread
    • #condition formatting #excel #comparison #excel #expert #excel #file error #excel #formula #confused #excel #pivot #excelquestion #fiter #if #match #index #index #match #nextclosest #pivot table#fiilter #sum #ignoretext #formula excel & formula excel & ilogic
    • Replies: 1
    • Forum: Excel Questions
  6. K

    Merge cell reference with other formula

    • krunal123
    • Thread
    • #condition formatting #easy excel #excel #comparison #excel #pivot #excelquery #excelquestion #filter #formatting #formula #if #match #index #pivot table
    • Replies: 4
    • Forum: Excel Questions
  7. K

    How to make OMR EXIM PAPER in excel ?

    All Question And Answer to save in "Sheet1) We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question Kindly make solution this query
    • krunal123
    • Thread
    • #condition formatting #excel #comparison #excel #formula #confused #excel #pivot #excelformula #excelquestion #filter #if #match #index #lookups #indexmatch #pivot table#fiilter #powepivot #powerquery #reference excel & formula excel & if excel & ilogic executeexcel4macro
    • Replies: 9
    • Forum: Excel Questions
  8. F

    Compare two values in two sheets and find in multiple colummns

    Lets say that i want to compare two values (C3) in two sheets {Main and secondary}, with the condition to find the same Site (Column A3) and Same Part number (B3) in the Second sheet . Additionally if the results is the exact same would like to set as "Match" if not I need the difference between...
  9. K

    HOW TOTAL QTY & RATE AS PER PRODUCT VISE FROM MULTIPLE SHEETS

    WE NEED SUMIFS FORMULA AS PER QUERY...... NOTE.: DIFFRENT-DIFFRENT SHEET IN PRODUCT POSITION IS CHANGE , HOW TO GET TOTAL QTY & RATE AS PER PRODUCTS
    • krunal123
    • Thread
    • #easy excel #excel #excel #comparison #excel #error #excel #formula #confused #excel #pivot #excel tricks #pivot table #pivot table#fiilter
    • Replies: 2
    • Forum: Excel Questions
  10. K

    How to Highlight RAW After Bold Text ???

    How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also
    • krunal123
    • Thread
    • #cell #highlight #colour #condition formatting #conditionalformatting #excel #comparison #excel #formula #confused #excel query #ifconditional #logical #if #excel2016 #logicfunction #pivot table #pivot table#fiilter #vba #excel excel & formula
    • Replies: 5
    • Forum: Excel Questions
  11. K

    How to Highlight Cell color After another "Invoice No." Value is Bold Text ???

    • krunal123
    • Thread
    • #excel #excel #comparison #excel #discrepancies #excel #error #excel #expert #excel #file error #excel #formula #confused #excel #minimum #index #excel #password #macro #excel #pivot #formula #formulahelp
    • Replies: 1
    • Forum: Excel Questions
  12. K

    How to change month After select Dropdown list ???

    • krunal123
    • Thread
    • #condition formatting #conditional formatting #excel #excel #comparison #excel #error #excel #formula #confused #excel #minimum #index #excel question #excel tutorial #formulahelp #pivot table #pivot table#fiilter #pivot tables #tables #sumif #indirect #index #vba #excel #if formula #explaination
    • Replies: 6
    • Forum: Excel Questions
  13. K

    How to Auto calculate Amount on the basis of particular Text i.e. "Total" Instead of Whole Text

    • krunal123
    • Thread
    • #database #pivottable#vba #excel #comparison #excel #formula #confused #excel #minimum #index #formula #countif #vba #pivot tables #tables condition formatting easy excel filter advance criteria if conditions pivotable vba filter table auto generation
    • Replies: 0
    • Forum: Excel Questions
  14. K

    How to make Date Period vise Filter on Pivot Table ?

    • krunal123
    • Thread
    • #condition formatting #excel #comparison #excel #pivot #excelformula #filter #logical #if #excel2016 advance fillter dynamic filter excel & ilogic pivot and power query pivot table pivot table % formatting powerquery
    • Replies: 0
    • Forum: Excel Questions
  15. K

    #HOW TO FIND MISSING "BILL NUMBER" IN MY LIST ??? ( MY FORMAT : EXP/001/2021 )

    This Formula use , Missing Date find perfect , but we need Find "Bill Number " , Because my file Large Amount of Bill Numbers ( May be 3000 Bill Number ) =SMALL(IF(ISERROR(MATCH($E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2,$B$3:$B$7,0)),$E$2+ROW(OFFSET($B$2,0,0,$E$3-$E$2+1))-2),ROW(A1)) ( This...
    • krunal123
    • Thread
    • #condition formatting #database #easy excel #excel #comparison #excel #file error #excel #formula #confused #excel #minimum #index #excel query #if #match #index #lookups #indexmatch #matching #searching #pivot table#fiilter #powerquery
    • Replies: 3
    • Forum: Excel Questions
  16. K

    Get SUM Total After Target ROW Via Formula ????

    • krunal123
    • Thread
    • #cells #autoaupdate #date #chart #conditional formatting #excel #comparison #excel #formula #confused #excel #pivot #excel formula #excel query #excel#sum #pivotable #sum #if easy excel tricks
    • Replies: 1
    • Forum: Excel Questions
  17. K

    #Found Duplicate & set Hyphen Symbol - via Formula based

    I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn
    • krunal123
    • Thread
    • #chart #condition formatting #conditional formatting #easyexcel #excel #comparison #excel #formula #confused #excel formula #highlight#cell#based#value #if #match #index excel & formula excel & lookup & search nesting if statement
    • Replies: 8
    • Forum: Excel Questions
  18. K

    How to set Custom Formatting via Formula?

    My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    • krunal123
    • Thread
    • #chart #conditional formatting #deskboard #dynamic filter #dynamicranges #easy excel #excel #excel #comparison #excel #error #excel #formula #confused #excel guru #excel logic #excel question #excel tutorial #filter #formulahelp #formulas #pivottable #pivot #powepivot #powerquery excel & formula
    • Replies: 7
    • Forum: Excel Questions
  19. K

    How to remove unuse area in classics pivot table ?????

    i need only one Column , how to remove unuse area in classics pivot table ????? Show me how to delete empty column formatting
    • krunal123
    • Thread
    • #database #pivottable#vba #excel #comparison #excel #formula #confused #pivot table#fiilter #pivot tables #tables #pivotquery #vba #excel #batch excel & ilogic excel & lookup excel & lookup & search formula #explaination pivot table
    • Replies: 0
    • Forum: Excel Questions
  20. K

    How to match Same number via join data ( As per Image Below)

    How to match Same number via join data NOTE: Not use this formula ( =+C3&" "&D3&" / "&C5&" "&D5&" / "&C6&" "&D6) WE NEED THIS PERFECT FORMULA IN THIS QUERY
    • krunal123
    • Thread
    • #easy excel #excel #comparison #excel #formula #confused #excel #minimum #index #filter #match #lookup #pivotable excel & formula excel & lookup & search logic formulas pivotable vba filter
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top