1st

  1. N

    Database as weekly reminder

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

    Formatting report - Pivot table

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

    Acquire 1st Two Non-Blank & Non-Zero Numbers in Row

    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]
  4. M

    multiple fields on multiple sheets

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

    Assign an index to each group identified by date

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

    combine 2 formula

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

    Vlookup or Index the last or 1st Non zero value

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

    Website Scrapping in excel

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

    if function problem need solving

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

    Counting data

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

    get standard deviation from every 1st, 6th and 10th cell in column

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

    Question data validation with conditional formatting

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

    SUMIFS with OR wildcard

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

    Old template to new template... about 400 times

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

    How to pick 1st word

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

    Insert Copied Cells Based On The Value Changing In Column A

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

    Date if

    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?
  18. R

    Excel - non vba code - Associate a Text Phrase to a Group of Ranked Numbers

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

    Count 1st character max occurrences as long as it find

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

    Understanding how a formula works

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top