#pivotable

  1. K

    how to generate Next invoice number After search table1 in excel ?

    how to generate Next invoice number After search table1 in excel ? Dear Sir, pleased Solve My Query We need formula For increase invoice number......
    • krunal123
    • Thread
    • #combination #excel #formula #confused #excel invoice #excelquery #excelquestion #if #match #index #if condition #pivotable
    • Replies: 3
    • Forum: Excel Questions
  2. K

    We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also ? how its possible on VBA coding ???

    We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...
    • krunal123
    • Thread
    • #conditional formatting #excel #expert #excel #formula #confused #excel query #formulahelp #pivotable #powepivot #powerquery #vba #vba #excel #vba #excel #if #vba #excel #pleasehelp excel & if tracking system vba & conditions
    • Replies: 0
    • Forum: Excel Questions
  3. K

    #how to using Combo box1 to Range A2:A8 ??? and i will increase & decrease cell size at time auto set Combo box size As per cell ?

    • krunal123
    • Thread
    • # new post #excel #excel vba #combo box #conditionalformatting #excel #expert #excel #formula #confused #macro #vba #pivotable #power query #vba #excel #vba #excel #if #vba #excel #pleasehelp #vba tips vba & conditions
    • Replies: 0
    • Forum: Excel Questions
  4. Z

    Text Hyperlink in Pivot

    I am working on a project on an Excel database. My source data has a column with values hyperlinking to a different source. They work fine when in the table, but when I create a Pivot, that column with hyperlink values shows up as plain text, and when clicked on them, they don't redirect as a...
  5. J

    Pivot Table Row Consolidation

    Hello, I have the below list of values that I want to put in the "Rows" section of my pivot table: Values: Invite to Round 1 Invite to Round 2 Invite to Round 3 Round 1 Conducted Round 2 Conducted Round 3 Conducted Is there a way to consolidate these values in to one row of the pivot...
  6. 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
  7. 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
  8. K

    # Get data After match "Code" Both table, Need Result Table2

    # Get data After match "Code" Both table, Need Result Table2 we need result in table1= 2.50% (Both Table Name Already in red font) How it Possible ??????
    • krunal123
    • Thread
    • #chart #excel #discrepancies #excel #formula #confused #lookups #indexmatch #pivotable #reference #rename #folders #excel formula #explaination table arrays reverting vlook up problem
    • Replies: 3
    • Forum: Excel Questions
  9. 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
  10. 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
  11. K

    How to Highlight Cell After match Both data ???

    • krunal123
    • Thread
    • #condition formatting #conditional formatting #easyexcel #excel query #excel support #excelquestion #logicfunction #mr.excel #pivotable #powepivot #powerquery #vba #excel #pleasehelp excel & formula excel & lookup excel & lookup & search excel search find filter advance formula #explaination formula & filter search & replace
    • Replies: 3
    • Forum: Excel Questions
  12. 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
  13. 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

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