pulled

Good morning, I'm using the below formula to display the oldest date in a range (to the end of the month) if there is a % value in a designated cell range. =EOMONTH(MAXIFS('FA Afford'!I22:I33,'FA Afford'!E22:E33,">0"),0) In an older version of the document I'm using (where the cell ranges...

Hello, I am pulling 2 different dates via VLOOKUP into cells in a spread sheet and then wanting the difference by day returned. The problem in the dates being pulled have time in the also so when I want the different to be zero it returns .29 or something like that...

ok so the data i pull in has the date in this general form: 20190502 .....I want to covert that easily into a date format so that I can compare the number of days between the pulled in date and another date is there an efficient way to do this? ideally via VBA.

I have two worksheets. One is old, one is new. The new sheet needs the same info pulled in as the old sheet, but in a different order, by last name. There are two columns of info associated with the last name, each will need pulled in separately. I have tried a couple different formula with no...

Hello All, Here is example of cells on Sheet2: A1 = 21 A2 = Sheet1!B21 (where 21 is pulled from A1 on Sheet2) I tried A2 = Sheet1!B($A$1), but this didn't work. Thank you! B

Hi All - Please find my "code" for a working IF(VLOOKUP... that does capture the data from the references table successfully. To start at the beginning, I have 5 value tables where data is being pulled from with a master table that is pulling the data from the 5 tables. My issue is that cells...

I have the following filter set up. = Table.SelectRows(#"Promoted Headers", each ([Transaction_Type] <> "I") and ([Contract] = "contract name") and ([Month] = 5)) I would like it so where [Month] = 5, the 5 is actually pulled from a cell reference so the end user can look at different months...

If I put "East" Under the shops in my Output sheet, then all the rows which contains "East' in the Reference sheet should get pulled up. The problem is that Shops column contains input like this "East, West and North", "East and South". It would have been easier for me to extract data through...

FORMULA for O6: This is my Remaining amount I need displayed for the year, however, I need the information pulled from one cell before another cell is pulled. K6 (last year amount)+L6(amount I can rollover to next year)+M6(amount I borrowed from the next year)-N6(the amount I used for the...

I am working on a report to return a value if criteria is met. I've filled in the table below for the Next Production Qty and Next Production Date that i'd like to see populated, I just need help with a formula to help me do this since there are 20-30 items per customer and dozens of customers...

i have this formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) It brings in the name of the sheet perfectly. But when i use that cell as a source of data for other formulas it does not work. It doesn't seem to be able to read the value in the cell. Example: the sheet is...

Good afternoon. On my password protected worksheet (NOx ppm), i am wanting to hide rows 38, 40, 52, and 57 based off the value in cell F40 on the same worksheet. The value in cell F40 is being pulled over from worksheet (Inputs). If the value in F40 is <=0, i want the rows 38, 40, 52, and 57...

So like the title suggests, i need to be able to pull info into cells below based on the first cells data. So for example. I have a doc and in A1 i have Hewlett Packard, i would like to be able to search a different excel doc sheet that has a large list of names in the A column with 6 rows of...

Is it possible to combine specific data from multiple worksheets? I have worksheets different people fill in so they're all identical as far as structure. I'm assuming this is more than just a simple formula. Secondary question can specific data be pulled from other sheets? For example I have...

I am doing a project with a T-shirt print shop. I want to know if it is possible to create on a UserForm a picture of a T-Shirt that they can circle where they want the log printed at. If it is possible, then when they click "submit" where will the image go? Can it be assigned to a cell that...

Not sure how to do this, and I am sure it is not too hard to do but I couldn't get it to work. Trying to start up a sports spreadsheet and want to do a web query where a part of it is pulled from certain cells. For example this is the website I want the query to be pulled from...