#easy excel

  1. K

    # Auto filter data According Particular Column base ?????

    ( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"
    • krunal123
    • Thread
    • #autofilter #conditional formatting #easy excel #easyexcel #excel #file error #excel #formula #confused #excel #minimum #index #excel #pivot #excelquery #excelquestion #filter #filterwithmultiplecriteria #if condition #logical #if #excel2016 #pivotable #power query #vba #dates #sumif #vba #excel #if excel & formula
    • Replies: 1
    • Forum: Excel Questions
  2. 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
  3. 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
  4. 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
  5. K

    # HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFRENT-DIFFRENT TABLE ???

    # HOW TO MATCH "HSN CODE" AFTER PULL DATA ON DIFFERENT-DIFFERENT TABLES ??? We need pull data into different- different Table . Kindly Help on solve my Query, Kindly Send us Proper formula , - perfect match " HSN CODE" And pull data from TABLE1 , send to matching table
    • krunal123
    • Thread
    • #dynamicranges #easy excel #excel #formula #confused #excel #minimum #index #excel #pivot #excel query #excel question #excelvba #filter #index match #pivotable #power query #queries #reference #table formula excel table formula #explaination
    • Replies: 1
    • Forum: Excel Questions
  6. 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
  7. K

    How to Get Number Between Slash "/"

    Between two Slashs "/" Or Two and more Slashs how to work formula in this condition
    • krunal123
    • Thread
    • #condition formatting #easy excel #excel #excel #discrepancies #excel #formula #confused #excel #pivot #excelguru #excelquery #excelquestion #filter #formula #highlight#cell#based#value #logical #if #excel2016 #pivot table
    • Replies: 4
    • Forum: Excel Questions
  8. 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