makes

Greetings, I have been wracking my brain trying to come up with a solution to an Index Problem. I am looking to have a formula look at an entire sheet, return the largest Number (from a column) but only if a cell in a column meets a condition. In my example I have Column A with Directors and...

Hi all I am looking for a Formula that would solve a problem like this: =IF(BASE!BI:BI,1,LOOKUP(DAILY!G2,BASE!D:D,BASE!AV:AV So I want to search for the value in DAILY!G2 in BASE!D:D and if found return the appropriate value from BASE!AV:AV to CELL BJ2 in DAILY! ie If the IF requirement is...

Hello All I am currently trying to do a 2 way lookup with unsorted data. So let's say that I want to return the value for where the value matches number 4 on my left column and G on the overhead row. So where 4 and G intersect return that value. In this case it would be 700. and the same for...

So I have a spreadsheet that has over a A HUNDRED AND FIFTY THOUSAND entries that makes it almost unusable. I didn't make it, but I am required to filter out everything except what belongs to me. I am looking for a way that I can filter based on a list. I have 59 names that is need from this...

I currently have a workbook that when data is entered in column A it will return a time stamp in column I with the help of the if statement. This works great however it makes my workbook very slowwwww. Is there another way or a VBA code that could do this same thing that could improve my...

I've been fiddling with this for hours and can't make sense of it so figured I'd ask for suggestions. I'm trying to work out a formula in column C that will display select values from column A as pictured below. I'd like it to do this only if there is more than one occurrence of a value in...

hi all, I am hoping this is possible but need some more experienced help. I hope this makes sense. I am trying to find out if there is a way (using formulas) to look for any value greater than 100 in column N and put the numbers into column BB in column N almost every second line has a number...

I need to add together the SUMPRODUCT from 5 sheets. I have tried a few things (,, --,+,AND, repeating SUMPRODUCT). This is what makes most sense to me, but it does not work...

Hello, I have a workbook with hyperlinks to files on my PC. How can I highlight a range of these hyperlinks and have them all open please? They are all pdf files if that makes a difference.

Hi All, I have a macro which makes AdvancedFilter in meals database. It makes filtering for all meals perfectly except, if CriteriaRange includes “SALAD”, with "SALAD" it filters "SALAD BAR" too. I need exact match, in this case "SALAD" only. Thank you in advance

This may be a silly question but if I have data that comes out of a data base in say this format..... 37.6379 and I want it to only show 37.6 (other than using the buttons in the ribbon to only show 1 decimal place) is there a formula that makes the number only be 37.6? Thanks!

In order to find the rows of table A that are NOT in Table B, one can use M in a query. e.g., Table.NestedJoin(Employee,{"EmpID"},#"Employee Salary",{"EmployeeId"},"Employee Salary",JoinKind.LeftAnti) How can it be done in DAX, perhaps using GENERATE. GENERATE or GENERATEALL makes it easy to...

Morning all I have a database full of dwell times (for drivers on site) that are in the below format. Is it possible to insert a slicer that can be changed to have options to select all entries over 4, 5 & 6hrs? When I am inserting the slicer it is listing all entries and as you can imagine...

Hello, I have a spreadsheet which has 60,000 rows, calculations on every line over many columns. Using Index/Match a lot of the time, makes the spreadsheet very slow and large, are there any alternatives; or maybe someone could suggest a different approach? Many thanks.

Hello everyone! I need to create a formula that will allow me to make a list in the following sequence: PC8101A PC8101B PC8101C PC8101D PC8101E Then repeating all the way to PC8100E Is there a macro I can use for such? The first two letters will never change, the last is always a single...

Hi all Bit stuck, want to look at my sheet and add a = SUM calculation I am using last command to find the last row last = Cells(Rows.count, "F").End(xlUp).Row so how do I put into my sheet ? =SUM(G2:last row) hope this makes sense ps please put comments on the example as I am still...

Is it possible to add code to an already existing script that encompasses ALL fields in the userform and makes them mandatory, or do I need to list each field separately in each form?

I have the following VBA code, but I want to limit O22 at 0 because this is a breakeven analysis with multiple revenue-drivers. The idea is that if O22 is 0, then this is sufficient information. Those using the spreadsheet do not need to know that O22 can be "(999,999,999)" and still...