advance

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...

<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

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

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>...

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

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

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

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?

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.

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...

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...

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

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

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...

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...

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...

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

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...

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...

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...