e14

  1. C

    Counting with blank cells

    Hi everyone, I have a formula like this in cell E14: =IF(COUNT(C14:D14)=2,(D14-C14)*24,"") which is checking that there are numbers in both cells, if yes find the difference, if no leave blank. This formula repeats a number of times along a row with different cells referenced. At the end of...
  2. V

    Copying data from one workbook to the last row or another

    Hi everyone, Here is the code I have so far: Sub ValuePaste() Dim loLastRow As Long ThisWorbook.ActiveSheet.Range("E9").Copy With Workbooks("test.xlsx").Worksheets("test") loLastRow=.Cells(Rows.Count,3).End(xlUp).Row + 1 .Range("C & loLastRow).Paste.Special Paste:=xlPasteValues EndWith End...
  3. B

    Can I add a match function to Achieve a search

    I'm currently using this formula to provide me with the last three full entries in a row, but I wanted to see if I can add a match feature, where it will match the team in cell E14 with E2:E5 then run the current formula. =INDEX($F$2:$S$2,COUNTA($F$2:$S$2)-COLUMNS($F14:F14)+1) I assume Match...
  4. M

    Subtraction of multiple cells

    Windows 7 - Excel 2007. I use this syntax in Cell E14: +E3-E5-E6-E7+E8-E10-E11-E12-E13 Data in Cells E3 to E13 contain only positive numbers and do not contain negative numbers. (Negative numbers, I mean like -1457). Cell E9 is blank. I request the necessary formula to be input in cell E14.
  5. N

    Difficult Timer question

    I'm stuck on a timer issue. I need a timer that is automatically activated upon opening excel (not clicking a button to activate it) I have multiple sheets so far and I need a timer to automatically add the value from sheet1 C14 to cell E14 in the same sheet every 3 seconds. C14 starts at 0 but...

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