Search results

I can't test this at the moment but maybe try changing all instances of MONTH in pecoflyer's formula in msg#6 to EOMONTH ?

=FILTER(Sheet1!G2:H7,Sheet1!J2:J7="Yes","None")

Power Query solution at cell F1 in attached. Differences: Cell G5 has removed both matching Dede.Hickmans G6 has more results than yours.

This is an awful solution but I think it works. In the attached: Sheet1: You can delete everything below row 6 in this sheet. Formula in C3, copy down one cell to C4 Formula in cell B4 Copy B4:C4 down as far as you need to. These formulae all use a reference to cell A2 of Sheet2, so on to...

It looks like you're using Excel 2007 ! Is that correct? If you were using a more recent version it would be easy with WORKDAY.INTL which allows you to specify exactly what weekend days are. Am I right that your weekend is only Sunday? Excel 2007 only allows WORKDAY which assumes your weekends...

The 3 bits you mentioned in your first message have already been addressed; those things all pertained to what happens within a cell. To address the new things, the code below: 1. skips blank cells 2.1. removes all bullets wherever they are in the cell (including those not at the beginnng of a...

In this case, if you change type before filling down, all is OK!

…continued from above. Apart from putting the CFs in an appropriate order to ensure you get the CF appearance you want, if that ends up being difficult you can also change the formula to make CF rules 'exclusive'. Here the CFs can be in any order:

Yes, conditional formatting is very confusing indeed. When I had a look at this I thought it wasn't working as it should and Stop if True seemed a bit random! So looking into it a bit deeper I found where I was going wrong. The first thing I noted was that the first of the conditional formats...

…or call this instead: Sub blah(myRng) For Each cll In myRng cll.value = Evaluate("TEXTJOIN(CHAR(10),TRUE,""•"" & SORT(TEXTSPLIT(" & cll.Address(external:=True) & ",,CHAR(10),TRUE)))") 'or, to treat lines which have only space characters as totally blank lines: 'cll.value =...

Guessing a lot. You can use a formula to get a result in another cell; this one looks at cell S2:=TEXTJOIN(CHAR(10),TRUE,"•"&SORT(TEXTSPLIT(S2,,CHAR(10),TRUE))) Convert that to a spilling formula that works on a column of cells, S2:S5...

Very easy in Excel, in D2: =XLOOKUP(A2-1,A1:A$2,D1:D$2,1,,-1)*C2 copied down, but haven't been able to do it in Power Query yet!

Both the absence of VSTACK and you wanting to assign missing values makes it difficult for me to put together a formula for this. I think I can put together a user defined function using VBA which would mean that the workbook would have to be a .xlsm file and macro-enabled but the formula you'd...

In cell D7 of your latest workbook you have the yellow highlighted desired result of EBU36001, yet in cell A13 you already have EBU36001. I'm going to assume this is a typo and that A13 should be something else, perhaps beginning ERE36… . So if I overwrite A13 with anything else, just to take it...

See formula in cell E3, copied down. It may have to be array-entered (use Ctrl+Shift+Enter instead of plain Enter to commit the formula to the sheet depending on your version of Excel. Cell E2 is a bit different.

A lot it would seem: and @vletm 's is a value you can do arithmetic with while @ExcelGoogler 's is text (although Excel's implicit data type conversion would probably come in if needed)! I've assumed UK style dates. Edit post posting: Looking more closely at @uday 's formula I'm guessing...

If indeed the data is to be moved (not copied) what happens to the data on the same row in columns H and to the right, of the Master sheet? Similarly, when moving from Lab to Lab what happens to data in the row to be moved beyond column G?

Yes, supply a workbook with this in it. There are lots of questions which will be answered by seeing that: What module is the code in? what is the Me referring to? what's on sheet details? what is Userform3 and what's on it? what is Userform1 and what's on it? are these userforms modeless? and...

Aaaaagh! First, there's very, but very, likely a much more straightforward solution than the one I've produced; it's just the route I ended up taking after experimentation and the first one that seemed to work. Look at sheet Sheet2 (2) of the attached where I've put the full version of the...

See conditional formatting in cells B2: P6 of the attached. It highlights repeating 1s when they're part of a run of 13 or more. If you want to highlight repeating values, whatever those values happen to be, change the CF formula from: =RepeatCount(B2,$B2:$P2,1)>12 to...

At first, I didn't respond to this question because all I came up with seemed convoluted and long while I felt sure there'd be a simple, elegant and robust formula for what is a simplish request. Now that others have responded without such a neat formula here's my offering, quite similar to...

change the 8 to a 9: =HYPERLINK("#"&LEFT(A2,2)&"!"&ADDRESS(MATCH("Total",INDIRECT(CONCATENATE("'",LEFT(A2,2),"'","!H:$H")),0),9),CONCATENATE("Pmts day ",LEFT(A2,2))) Highlighting doesn't show in the above so...

=SUMIF($A$8:$A$19,A2,$B$8:$B$19)copy down.

In cell E2:=SUM(COUNTIF(B2:D2,$G$2:$G$7))>0May need array-entering onto the sheet (using Ctrl+Shift+Enter instead of just plain Enter) depending on your version of Excel. Then copy down.