#database

  1. 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
  2. P

    Pivot Table with monthly data per columns

    Good day everybody, New to this forum, first post. I guess this question has been addressed before but I've been unable to find anything in the existing thread. Don't hesitate to re-direct me if necessary. So my question: I have a table, as per below screenshot, recording some consumption...
  3. E

    Need VBA help for Excel Database

    Ok....So, I am currently working with an excel database that links client information entries to a Word note file located in the client's digital file. What I'm trying to do is three fold; I'd like to be able to code the "notes" cell on the client's row to auto-populate the next available entry...
    • EMMJAY
    • Thread
    • #autopopulate #database #help #vba #help #word #excel #large #outlook task #vba #copypaste #vba #excel #word
    • Replies: 0
    • 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