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

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top