evening

  1. N

    Protecting a Workbook...

    Good Evening to All... Can a workbook be protected from being copied ??? Thank you.
  2. B

    Clear Array

    Evening all something simple - maybe someone can explain why the the below errors out Sheets(Array("Sheet2", "Sheet3", "Sheet4")).Range("A1").CurrentRegion.Clear
  3. R

    Stop returning results after the first match.

    Hoping this is possible. In B I have a list of papers In X there is an IF(AND formula which tells me whether a product type (EU) is suitable for the paper or not. Where there are multiple papers, I'm seeing multiple EU's - I only want one, however. <tbody> B V W X Preferred X Result...
  4. S

    Excel Query for converting time stamp into morning, afternoon, evening and night

    I have below excel sheet table and I want to convert the given time stamp into morning, afternoon, evening and night. time between 12 am to 11 am - morning, 12 pm to 3 pm- evening, 4 pm to 8 pm- evening, 9 pm to 11 pm- night. Please suggest <colgroup><col width="64" span="2"...
  5. B

    Counta

    Evening all Unsure why the following is resulting in an incorrect value. Cells(1,7).value = application.WorksheetFunction.CountA(Range("B:B")
  6. L

    Using Function IF

    I just need some help to make a formula and just cannot figure it out. I want excel to automatically input Day, Evening, and Night I know i have to use the IF function but how to phrase the formula is the problem when my other cells have certain ranges. 2300 - 700 Night 700 - 1500 Day 1500 -...
  7. R

    Multiple lookup

    Hi, I've been trying to figure out the fomulas to do the following: I have the data below and what I want to do is a lookup on multiple criteria to fill in the cells on another sheet. On my other sheet I have sections split into days as here: A1 Date: 27/11/2017 A2 Night : 24975 A3 Day ...
  8. S.H.A.D.O.

    Using VLOOKUP with RIGHT function..

    Good evening, I have text in cell I6 of the current Worksheet with a number at the end of it. Some sort of text here 2,126 I want to use the number 2,126 in the text above to VLOOKUP the number 2,126 in another Worksheet. Here is the formula I am using but can't seem to get it to work...

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