1st

i have a series of clients that need work doing. each one has house work on at a different frequency. some weekly, some 2 weekly, some 6 weekly etc. in additional these clients have garden work on at a different frequency I would like to be able to add these clients to a database, say the work...

I have a spreadsheet to track documents issued, when and a transmittal number. The transmittal can have multiple documents and each document can have multiple revisions. Where I am stuck is trying to format this data into a report based on documents or on transmittal. I have tried using a...

Is there a simple Excel function that will permit me to acquire the first 2 non-blank, non-zero numbers in a row? In the picture below, I'd like 24 to appear in 1st Score and 6 to appear in 2nd Score. As always, thanks in advance for your help! [/URL][/IMG]

Not even sure if this is possible. I have a workbook with 31 sheet and want to st up an extra sheet that pulls all the data from A22 to h42 into a list to look like 1st A22 B22 C22 E22 F22 G22 H22 1st A23 B23 C23 E23 F23 G23 H23 and then so on that I can then drag to change the "1st" to...

Hello. In column A (A1:A600) I have a dates and time in format dd.mm.yyyy - hh:mm (example. 07.10.2019 - 21:00). Somehow I need to find an 'average' date for all those dates in column A (split data/dates in column A into two parts) and then to assign an index to each date (column A) according...

Hello I am trying to combine 2 formula but have difficulty as i do not understand excel that well, these are the 2 formula below 1st =IF(IFERROR(VLOOKUP(TEXT(B3,"dd/mm/yyyy"),Holidays!A:A,1,0),0)=TEXT(B3,"dd/mm/yyyy"),"off Peak" 2nd...

Hi, There are quite a bit of lookup last or 1st non zero value in a row or column as below link http://www.xldynamic.com/source/xld.LastValue.html Is there a way to combined it with vlookup, OR sum(if(criteria, if(criteria,range))), so we can search a range based on some row and column match...

I need query to scrape following website link data into excel spread sheet https://urlzs.com/11Wc9 There are 18,839 properties results appearing on above link. Fields I am looking to be exported into excel are price, location, telephone, square meters and the link of that property. 1st case...

Dear Pros, Please help me with 1 function that can determine whether there is any gap by item name. example1: For itemA, "Cell E1" will show "No Gap" if b1,c1,d1 all are"No Gap" example2: For itemA, "Cell E1" will show "Gap to 1st" when b1 ="Gap to 1st" while C1 and D1 ="No Gap" example3...

Assume I have this column of data: a b c d e a b If I type in cell D1: =COUNTIF(A:A,A1) and copy the formula down, I get: 2 2 1 1 1 1 1 which is correct. But what I am seeking is: 1 of 2 ' because it's the 1st a of 2 1 of 2 ' because it's the 1st b of 2 1 of 1 ' because...

Hello I have a column of data. The # of rows are always multiples of 10. How to get the standard deviation from the cells in each 1st, 6th and 10th row? For example if I had 100 rows. I would want the standard deviation from rows 1,6,10,11,16,20,21,26,30...91,96,100 Thanks Tom

I am trying to figure out if there is a way to use conditional formatting with data validation list like this. 1st I have a list from data validation of performing a task. I will use 4 task that I do once a week. Mow grass, wash dishes, wash car, clean pool I want to set a time for each, and...

I am stuck trying to do a sumifs where a partial match = set criteria <tbody> Price Group Country Volume A <100 - 499 GB 1790 B 500 - 1000 GB 5232 C 1001 - 2000 DE 9958 C 1001 - 2000 GB 4556 </tbody> so If i want to sum the volume where price group >= 500 I'm thinking along the lines...

I have about 400 files in an old template. The data in each file needs to go into a new template. Most of the cells between the 2 templates don't match (cell B7 in old template may go to cell C14 in new template, even in a different tab sometimes). ... I really don't want to do it manually 1 by...

Hi I want a formula to pick 1st word from the sentence , please help Jack & Jill = Jack Please come = Please Gross Margin = Gross

Hi all, I am trying to insert copied cells into another spreadsheet based on the value changing in column A, if it changes the rows are inserted underneath the 1st value and before the 2nd value. What I have currently is the below however I am seeing some anomalies. The codes is activitate...

How do i create an if statement that looks at cell C6 and says if it is between 1/1 and whatever year and 3/31 whatever year that it returns 1st qtr or if it is between 4/1 and 6/30 then 2nd qtr and so forth?

I have ranked a list of players by score (low to high using the Rank function) and wish to designate (using text) the present standing (1 to 5 places) of the player. If 2 players are ranked 1, the next lowest player(s) would be ranked 3, etc. I would like to designate, via text in a Notes column...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> My data are in the column C:P, require results in the Column R:T</SPAN></SPAN> For example count max occurrences of the 1st character find in the each row</SPAN></SPAN> Row 6 1st character X max occurrence=1, result In S6=1</SPAN></SPAN> Row 7...

Hello all, I am confused with how the formula below works. What part of this formula makes the date know it's 2019? The result I am getting in B1 is Fri, 01/04/19 :confused::confused::confused::confused: Cell E3 - 1ST FRI EVERY JAN Cell F3 -...