fine

Hi everyone, I have a formula that populates Y or N based on a few criteria (also has conditional formatting that shows Y as Green and N as Red). The formula is working fine for that purpose however, when there is an error the cell populates #N/A (this is fine) but I would like the cell to be...

Hi all, I want to somehow condense the red and blue sections below so my formula isn't so bulky. Background: this formula is returning the first or last invoice date for select products depending on drop-down selection. All works fine... But Is there a way to condense this so I don't have to...

Hello Group, I'm having a problem I hope somebody has a solution to I am working on a macro that copies data from a pivot table to a new sheet then sorts the data from largest to smallest then filters the data. Everything works fine until I filter the data. After it filters, I lose the sort...

I have a report in Power BI, I Analyze in Excel, I have added several slicers, some of them work fine, but others if I use I get the following error. "The database driver does not include necessary capabilities and cannot be used with Excel. Contact your database administrator or driver...

Hi everyone, I'm in a bit of a pickle... I've got a VBA script that was working just fine... until I added the following lines: On Error GoTo here find_row = Workbooks("data.xlsm").Application.Match(Workbooks("data.xlsm").Sheets("Data").Cells(1,2), Worksheets("Data5").Range("A:A"),0)...

This formula is not working... =IF(BS17="R",VLOOKUP('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4))="","",if(BS17="R",vlookup('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4) The formula below is working fine...

Hi all, i have the following formula =IFERROR(LOOKUP(2,1/(($BJ$3:$BJ$5002=C5)*($BK$3:$BK$5002=I5)),BO5),"") Which should return the contents of BO5 but infact returns BR5 ? Any ideas why this would be? It works fine if used on row 3,4 etc Thanks for any help

I have created a complicated spreadsheet using excel 2007. I shared it at onedrive so some friends can download it and use it also. When they open it they are got the message that file is corrupted (they are using excel 2010-2013-2016) and some formulas and conditional format was gone at some...

Hi all, I've been using Excel for decades but I've only just started using VBA. I currently have a task that entails copying 600 cells from several sheets in one workbook to a table in another. And then repeating the process on 300 other workbooks The code is quite simple Sheets("Section...

Hello, I'm new and apologize for the bad formatting. I have a system generated report that isn't very excel friendly. There are 2 criteria I'm filtering by. 1) # and 2) date. Individually they are fine but combined they don't work. <tbody> # Date 1 6/27/2018 00:00:00 3 6/23/2018...

Dear friends, I have a formula, working fine but I don't know how to extend the query...!!! The query is in cell N8 : If L8 = "Buy" (M8-P8)+M8 Else M8-(ABS(P8-M8)) This works fine. But I want to extend it with the addition to the first formula : If K8 = "", N8 = "" Please guide & help...

Hi all In H3 is the date a task is due (formatted as a Date, I promise ;)) In O1 is =TODAY() In Col I from row 3 down I want to repeat the date shown in H3 (but only if it's due within a fortnight from today's date). This can be 14 calendar days, not business working days, that'll be fine. Is...

Hi, I have a column(assume A) with various numerical values from 0000 to 9000 (not in any incremental sequence). There is another column which has many ranges, like 1794-6317 in it (the lower and upper values will be valid and will be in the list). Is there any way to display the numbers...

Good Morning, I've got a database where I run a Select Query every morning that requires me to enter in today's date. It worked fine last week and last month, but as of today I get the following error: "This expression is typed incorrectly, or it is too complex to be evaluated. For example...

I'm baaaa-aaaack! With yet another (potentially) idiotic question - because it seems SO simple, and I've never run across this before. But I really have spent 97 minutes trying to solve it. So - here I am. Cell I7 has a formula that works fine in the entire column. =IF(F7=0,"",E7) Cell M7...

I have a query where I use the value from a Combo box on a form as the criteria Forms]![frmEstimates]![ComboPidSelected] This woked fine. But I need to adjust it so that when nothing is selected in the Combo Box that the query puled Everything. So I tried an Iff formula...

Hi - grateful for any help. I have a table and need to identify errors Namely I want E2 to turn red if greater than C2...that fine but when I try to extend to look at each row in turn ie E3>c3, E4>c4 im getting some strange results.... THANKS IN ADVANCE......

Hello, I'd like to sort some data in two differents sheets from a column (A) of the first one (Sheet1), I mean: Before sorting: <tbody> A B 1 1 Hey, 2 3 are 3 2 how 4 4 you? ... Sheet1 </tbody> <tbody> A B 1 Fine, 2 about 3 how 4 you? ...

Hey everyone. I am working on a worksheet that will have some basic columns, nothing set in stone yet, but essentially A8 would be an employee's name, B8 would be their expected return time, and other random data that is calculated. Let's say it is John Doe and he is expected to be back by...

I'm trying to lock the scroll area on multiple sheets and have it set for when the workbook opens. I've tried a few different kinds of code with varying degrees of success, but all end with getting an error eventually. The one below is the most recent one I've tried, and it was working fine...