k11

  1. F

    Concatenate(?) + Vlookup

    I have cell (K7) to enter a value for hours I have cell (K11) to enter a value for minutes In cell K15, I want the outcome to be HH:MM in decimalised form - 7h:30m = 7.5h Sheet 2 is where I've linked the Vlookup to for the minute conversion, how can I join together the hour figure from K7 and...
  2. jl2509

    Dynamic Range Selection

    Hi I am trying to setup a dynamic range using offset in name manager which will select every 6th cell in a row starting at E11 i.e. E11, K11, Q11 etc would be selected but only where data is present Any thoughts please.
  3. M

    Formula for picking date

    MS Excel 2007. Columns G and J are "date" formatted, "dd/mm/yyyy. In Column K the input is either 1 or 2. For example, if column K11 is "1", L11 should display the date as in G11. If K11 is "2", L11 should display the date in J11. G J K...
  4. B

    should I use and IF statment or conditional formatting?

    Good morning all, having a mental block today so would be grateful for some direction please. basically I'm at a loss on how to do this simple thing. Column K, K20:K173 is where I input data and I'm looking to add a formula in cell K11 that returns a the word "yes" based on the said columns...

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