brings

In F2 I have =IF(ISODD(ROW()),"",E3 E3 had the date, so it brings the date in numbers like 43466 instead of 01/01/2019 how do I add "MM/DD/YY" in the formula? I can format the column as Date, but I need to learn how to add this into the formula. Thanks

Hello All, I have a working formula but would like to add in: If the cell is blank then write in "NoGroups" Example: Result in Z2 =CONCATENATE(O2,P2,Q2,R2,S2,T2,U2,V2,W2,X2,Y2) And brings me up the result I need but would like to add NoGoups to cell Z2 I thought of IF(ISBLANK(Z2),"No...

I am trying to make a simple unique list from a large Column. There are various options on the web but do not seem to work. Here is one example that needs to be used in am array. {=INDEX(list,MATCH(0,COUNTIF($D$4:D4,list),0))} List is my Column of entries D4 is the cell right above "List" It...

There is a way to adjust your setting so that if you right click or double click (I don't remember which) in the cell it automatically brings you to the cells reference. Example If I have a formula in cell A1 on Tab1, and the formula is 'Tab2'!C5, and I double click it automatically brings me...

Hello, I am working on a project to take a bulk of information and separate it among several sheets within the same workbook. At the moment I have the following array formula...

Hi, For some reason when I use =TEXT([@PublicationDate], "dddd") Against 26/06/2017 in a table it brings in Monday which is correct. However if I use =FORMAT(DAY('Calendar'[Date]),"dddd") Against 26/06/2017 in a Table column in PowerPivot it brings in Thursday? ??? Any ideas whats going on?

I am looking for a formula to look up the same name then add up the total numbers next to it. It always brings back just one instance when I write my formula.

Hi, I am having issues with ranking on excel, it seems like the ranking formula is limited to 180 cells? after which it brings a N/A issue. Does anyone have solution to this?

Hi I have two cells, A2 is blank and the other B2 has a value. In a difference cell D2 i want do an if statement so it looks up both cells and brings back the cell that has a value in

hi all I have the below formula which looks at two date ranges and brings back values within that date range. The issue that I'm having is that "<="&$C$13 part isn't bringing back the last line in my date range i.e. it won't return the value in the 24/04/2017 00:00 one unless I type 24/04/2017...