advanced formula

  1. N

    Advanced Count Formula

    Hello, I am trying to count how many unique kits I have in excel. (A group of rows) Each Kit Starts with a P in column G and ends with the last C, before the next P, in column G. I need a formula that can identify the kits using the above logic and count how many unique kits there are please...
  2. L

    Modify Formula to Create Acronyms; Not Reference First 3 Characters

    Hello, Someone from this forum helped me create the below formula to automate and standardize the process of creating unique SKU's for my Shopify products: =UPPER(CONCATENATE(LEFT(CONCAT(LEFT(D2,1),IF(ISERROR(FIND(" ",D2)),MID(D2,2,3),MID(D2,SMALL(IF(MID(D2,ROW(INDIRECT("A1:A"&LEN(D2))),1)="...
  3. R

    Matching various values to one master

    Hi, I have a spreadsheet with various credit and debit amounts, what I need to do is match a number of the credits to one of the debits (exact amount needed). Is there a formula or macro that would enable me to do this. Help greatly appreciated
  4. F

    Attendance tracker - Calculating total occurrences of absence/tardies. Perfect attendance point reduction

    Currently everything is working as intended except for one feature, the 90 day perfect attendance reward. Weekends are excluded from the dates in row 5 so anytime I refer to 90 days it's 65 cells. (not perfect but it works for our use) I set up a situation in the attachment that shows the...

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