advance

  1. C

    Pull through data from table based on oldest date

    Hi all, I have a three column table, one column with a name, another with a date/time timestamp, and a third is whether that row is completed. I basically need to pull through a name to another sheet, but it has to be the oldest uncompleted. I just can't suss how to do it! Someone has...
  2. G

    Split value in half and add

    <tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT
  3. O

    Vlookup with variable lookup value

    Hello, Is it possible for a VLOOKUP to have a multiple lookup value. For example: =VLOOKUP(A1,'Data'!$A$1:$D$1000,2,FALSE) If the lookup value in A1 is empty it can look at a different lookup value in A2? Thanks in advance, Chris
  4. K

    Help, required single formula, instead of using 3

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> To get final result in the column K, I am using 2 more formula in the column E & G, please can someone make a single formula in the column K. </SPAN></SPAN> Using example....</SPAN></SPAN> <b></b><table cellpadding="2.5px" rules="all"...
  5. muhammad susanto

    Average With Exclude Text,Blank Cell, Zero Number

    hi all.. how to make average formula exclude 3 criteria text, blank cell, zero (0) =IF(COUNT(H8:T8);AVERAGE(H8:T8);"") but still not fully working thanks in advance.. .sst
  6. muhammad susanto

    Check If Cell Not Empy in Multiple Rows

    hi all.. how to check if cell not empty, say ok otherwise no <tbody> data1 data2 data3 data4 target 34 8745 898 ok no 56 ok </tbody> any help, thanks in advance. .sst
  7. J

    Conditional formatting highlight

    Hi, My formula seem to be wrong. Can any one please help me check the formula. Appreciate in advance. Thank you. https://drive.google.com/drive/folders/1GONwJfx01v_XZeHrg3burkBavuF3ffIJ?usp=sharing
  8. D

    Advanced Filter

    I am starting to use Advance Filtering, and notice that when I try to clear the filter, the table formatting is cleared as well. How can I just remove the Advance Filter settings without disturbing anything else on the table?
  9. K

    VBA for deleting cells

    Hello, I am looking for a VBA code that will delete all cells with a value less than 0.01 and shift cells up for column A and then to repeat the process for column C. Thank you in advance for the help. I really appreciate it.
  10. H

    MINUTE’s calculation

    I am looking for formula (in a cell F2) to get difference in MINUTES from D2 (system’s time being regularly getting updated) & B2 with a limit in C2 F2=0 IF EITHER D2 < B2 OR D2 > C2 How to accomplish? Thanks in advance I am using Excel 2007 Sheet1 <colgroup><col style="FONT-WEIGHT...
  11. E

    Easy way to delete Tabs

    Hi all, I was just wondering if anyone new a macro that deleted specific tabs based on part their name. I have a macro that creates new tabs, but every tab has "Sheet 1" in it, the later tabs have "Sheet 1 (2)", "Sheet 1 (3)", etc. I just need those tabs to be deleted at the push of a button. I...
  12. S

    No Margins

    Hi All, Is it possible, to have printout in Excel with NO margins (maybe with macro) ? Thank you in advance.
  13. J

    Broken system.. Need help.

    need help for those who are willing to help me .. thanks in advance https://www.dropbox.com/s/7fug39z9wg7q6b9/Audit%20Team%20Performance%20%20Scorecard.xlsm?dl=0
  14. D

    Sumif formula

    Greetings! Thanks in advance for any help! I love being able to find solutions on the forums but sometimes I don't have the best luck if I can't come up with the right key word or phrase when searching for it. I've got half of my solution it seems, however I'm now trying to sum a certain number...
  15. J

    Group and Sum Using a Filter

    Hello I am working an PQ view that will allow me to use the current column (Pipe Length) that I have added to sum but only if the column (PRGM_Code) is equal to"1". Ten I need to divide the (pipe Length) column by 12. We I use the dialog box "Grouped By" there is not conditional formatting...
  16. B

    VBA Beginner Question

    Hi all - I imagine this is very elementary but I can't seem to get it right. I'm very experienced with Excel but very new to using VBA. Appreciate all help: I have a table called Table1. I would like to copy from another worksheet on the row below the final row of the table. The macro...
  17. T

    If ... then or Select Case ?

    Hi Guys, Does anybody have experience which is quicker - long (If Then Else) construction or (Select Case) ? Thanks in advance. Regards
  18. M

    Excel Crashes

    Hi everyone, After installing Excel 2016, sometimes occurs the error "Microsoft Excel has stopped working", when I open a specific workbook, which has more than 100 sheets. To solve the problem, I have to open this workbook in other computer with Excel 2013, and save the workbook. Afterwards It...
  19. H

    Non Zero Value from a range

    Input Range C2:C8…ONLY 1 cell contains Non Zero value Output in D2 as Non Zero Value from C2:C8 How to accomplish? Thanks in advance Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody> C D 2 0 588 3 0 4 0...
  20. A

    Code frustration...please help

    Dim rData As RangeDim Lst As Long, LRow As Long LRow = Range("W" & Rows.Count).End(xlUp).Row Range("V18:Y" & LRow).ClearContents Set rData = Range("A18", Range("B" & Rows.Count).End(xlUp)) rData.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("W18"), Unique:=True With...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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
Top