#excel question

  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 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
  3. 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
  4. 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
  5. K

    How get Sum value via "HSN Code" vise ?????? (without pivotable / without filter/ without VBA)

    # How get Sum value via "HSN Code" vise ?????? Advance Condition : "if 100 or More Entries in sheets how it possible to solve query via Formula this Concepts " (without pivotable / without filter/ without VBA)
    • krunal123
    • Thread
    • #database #pivottable#vba #excel #excel #formula #confused #excel question #excelquery #power query exce formula formula #explaination
    • Replies: 2
    • Forum: Excel Questions
  6. K

    # How to Add symbol In Before Last Number ( With Cell Reference / Without Cell Reference)

    # Without Cell Reference : " Check This image " # With Cell Reference : A1 = MSCU1234560 i try Cell Reference G1 =+A1 ( with use formula like right / Left )
    • krunal123
    • Thread
    • #chart #deskboard #excel query #excel question #excel tips #excel tricks #pivotable
    • Replies: 4
    • Forum: Excel Questions
  7. K

    How to show All table in Power Query Editor ???

    • krunal123
    • Thread
    • #excel #formula #confused #excel filter #excel query #excel question #excel table #pivot tables #tables #powepivot #powerquery #power query #vb excel
    • Replies: 6
    • Forum: Power Tools
  8. K

    HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? (=+A2 According This)

    HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????
    • krunal123
    • Thread
    • #excel #error #excel #formula #confused #excel #minimum #index #excel #pivot #excel powerquery #excel question #excel tips #excel tricks #filter excel & formula excel & lookup & search pivotable
    • Replies: 4
    • Forum: Excel Questions
  9. K

    How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ???

    How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...
    • krunal123
    • Thread
    • #conditional formatting #databased #deskboard #excel #formula #confused #excel #pivot #excel query #excel question #excel tips #excel tricks #help #power query #report #vba #excel #if condition formate excel formula
    • Replies: 3
    • Forum: Excel Questions
  10. K

    How to marge 3 table , Without loss data ???

    I was try , 3 table marge but i was tried ...... i was remove this table , & make New table but this last Name Assign Problem ...... How make Running File Marge 3 table , Without loss Data...??? How to possible ??? Pleased Show me Step- by- Step.
    • krunal123
    • Thread
    • # excel filter #condition formatting #excel #comparison #excel #formula #confused #excel #pivot #excel query #excel question #excel tips #excel tricks #pivot table #powepivot #powerquery #power query #table formating #vba #excel #if excel & formula excel tables
    • Replies: 3
    • Forum: Excel Questions
  11. K

    HOW TO MATCH DATA ONE WORKBOOK TO OTHER WORKBOOK & MATCHING DATA

    # 1st Condition : MATCH Data 1st "SHEET 1 WITH '"SHEET 2" # 2nd Condition : "SHEET 2" MATCH DATA with other Workbook "SHEET 1" like this BOTH CONDITION MATCH AFTER SHOW ME STATUS " YES / NO " in Worksheet 2 > SHEET 1
    • krunal123
    • Thread
    • # excel #conditional formatting #data mating #double match #excel #formula #confused #excel query #excel question #formulahelp #matching #searching #pivotable #power query #vba excel & lookup & search
    • Replies: 1
    • Forum: Excel Questions
  12. K

    HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST

    # HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....
    • krunal123
    • Thread
    • #excel #excel formula #excel query #excel question #excel tips #pivot table #power query excel formula vba
    • Replies: 3
    • Forum: Excel Questions
  13. K

    Hide Row with Zero value with Entry

    Hide Row with Zero value with Entry
    • krunal123
    • Thread
    • #conditional formatting #excel #excel #formula #confused #excel query #excel question #excelguru #excelhelp #pivot #pivot table #power query #vba #vba #excel
    • 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