hammer

  1. D

    if a number= string to text

    so i have a long number from a barcode. 0190027182300349320100024711190409210219892014g in cells a6-a460 where the 3rd #to the 14th is fixed 90027182300349 and want cell g6-g460 output text tied to that number so 90027182300349 would = to blue 90027182232456 would=to red I tried the...
  2. A

    Translate Fill Color to a Value

    Hello All, Is there a way to transform a cell's fill color into some sort of data? (I've inherited a bunch of worksheets where each cell has a number value and then the fill color says what the value is for.....the previous person then counted the values by hand and put them in another spread...
  3. S

    Help with Reformatting/Calculating spreadsheet

    HelloAll, I am new to the VBA world, but I have beenusing the different threads here to answer some of my more basic questions, buti have kind of a complicated one. Here goes... I have an Excel spreadsheet that contains usertransaction data for an inventory system that we use. Each row...
  4. M

    Displaying a Range

    Hey all, trying to display a range of ounces for various laundry detergent but my formula has broke. Anyone see where im going wrong here? I'd like to have it display like this: 45 - 50 oz in cell F21.Thanks in advance... =IFERROR(IF(MIN(IF(B:B=B17,IF(A:A=" ",G:G)))=MAX(IF(B:B=B17,IF(A:A="...

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