fair

  1. N

    IFNA VLOOKUP with multiple repeating table arrays with filter

    Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail. I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...
  2. J

    fill in a cell if two cells meet a criteria?

    If 2 Criteria is meet then Cell = that percentage Increase. Example1 IF Cell A3= Hammer IF Cell B3= Poor Then Cell C3= 5.00% Example2 IF Cell A4= Socket IF Cell B4= Good Then Cell C4= 10.00% My Chart B5 = Socket E6 = Damaged F6 = 3.00% E7 = Poor F7 = 4.00% E8 = Fair F8 = 6.00% E9 = Good F9 =...
  3. K

    Find and replace multiple values in 43K row sheet

    Hello Excel Gurus, I'm seeking what I hope will be easy-to-follow advice for an average user! I have a sheet with 43000+ rows; I have to convert a column of information by matching the first few characters and replacing it with a full unit name. How can I do this with a formula that I can...

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