wash

  1. B

    Question data validation with conditional formatting

    I am trying to figure out if there is a way to use conditional formatting with data validation list like this. 1st I have a list from data validation of performing a task. I will use 4 task that I do once a week. Mow grass, wash dishes, wash car, clean pool I want to set a time for each, and...
  2. S

    Detecting Duplicate Pairs

    Please help!! I have a large list ofcompanies (approx. 180,000 rows) that placed bids on different contracts. I amtrying to determine how to figure out how many TOTAL times each company bidagainst one another. Any suggestions?? Sample dataset is below: Contract Number (Column A)...
  3. D

    Nested If/Or Formula

    Quickie help, please... I have a formula that calculates work days from two dates. The dates are in F and G. I've discovered that there are instances in the data where one cell has been left blank. I built a formula for if G is blank, then subtract F from itself (so it's a wash), and give me...
  4. R

    Any Formulas that simply copy cells and paste them farther down a row?

    Greetings, Example: I've got data in Row3 A2 B2 D2. Once that data has been reviewed/confirmed, I need to COPY/PASTE it over to M2, N2, and Z2 on the same Row. Then wash, rinse, repeat down each Row. Might that be possible via a Formula? I can't seem to find anything. Or would this be...
  5. R

    SUMPRODUCT issues

    Hello all, I’ve been using this formula for a while now, but I waswondering if I can get the formula to find WASH instead of the information on Sheet1!$A4.There are several different narratives for wash but WASH is always in thenarrative. Please help! Thank you foryour time...
  6. D

    Formulas making cells not match or work in IF commands

    Seems like a really simple issue to be honest but I'm having a real issue getting it to work I have 2 columns 1 is simply the date as =Today()+1 The other is a vlookup column matching vehicle registrations to designated wash dates I'm trying an IF function cell, true = a vehicle wash note...
  7. M

    Ratio Computation

    Hello guys i have a small laundry business, i want to know the ratio between the numbers of wash and the number of detergent used per day, i have i table like this <tbody>#DAE7F5[/URL] "] A B C D 1 Date Wash Detergent Ratio 2 August, 01 2018 6 4 3 August, 02 2018 5 3 4 August, 03...
  8. N

    Moving Text To End Of String?

    Is there a formula to move a specific text within a cell to the end of the string? For all rows in column W I would like to move “ / HOLD” to the end of the sting. If the cell does not have “ / HOLD” I would like to keep it as is. I would like the results to be in column X. Example...

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