correct

I am adding 4 columns, 3 of which have ABS totals. When I do =Sum( of the 4 columns I get correct sum but when I try to sort the 15 numbers from lowest to highest it does not put them in the correct order. The first column below is the total and this is after I sorted them. The first row of...

I only want to apply the ROUNDUP function when N8<O8, otherwise return N8. This formula returns N8 regardless, even if I swap the < for >. Can someone help with the correct syntax? =IF(N8<O8,ROUNDUP((O4*N5),0),N8)

Hi everyone, I'm stumped. In my excel file, B2 will always have a date. If C2 and D2 may display a date, nothing at all or zeros. I want the correct date to display in E2. B2 always has a date. If C2 has a date that isn't 0, I want to use that one instead of B2. And if D2 has a date that...

Hi, Please see screenshot: https://imgur.com/WEnzwsS I have so many issues with this condiational formatting, now I am facing this. Everything looks perfectly correct to me but the conditional formatting still colors the cell, why?

Hi, Please see formula: =IFERROR(INDEX('hours'!F5:BF2000;MATCH(P3;'hours'!A:A;0);MATCH(Q2;'hours'!2:2;0));"") It identifies row 6 & col 6= correct. But it does not return that value. What might be the issue?

I am using index match to fill in a form from data on a closed workbook. It works perfectly 99% of the time. However, it starts retrieving wrong data out of no where. Nothing changed with the formula. Just out of the blue it decides it will not pull the correct information. If I open the...

In the following code I am trying to use the For Each...Next statement to identify cells in a range that contain a particular string. Then I want to cut each entire column and move to Columns(1). There are usually at least 3 or 4 of these columns. At the moment the code is moving all columns...

Help with countifs statement if that's what I should be using???=COUNTIFS(Bramshaw!C3:N3,I1,Lulworth!C3:N3,I1)for Bramshaw the number relating to I1 is 3 and Lulworth I1 is 1.When I enter the formula i get an answer of 1 rather than 4? Am I using the correct formula to add them together...

Hi I am having difficulty with a Paste Special line in my VBA and cannot work out why. I have searched various websites and tried a load of different things, without success! The section of code is: Worksheets("Required Data").Activate ActiveCell.Offset(0, 2).Copy detail = ActiveCell.value...

Hello - Here's 1 for everyone . . . I have a sheet with item numbers and their associated barcodes. If I do a simple 'Ctrl-F', I can find the correct one but using the scanner to try to scan the correct barcode from a laptop screen full of barcodes is proving difficult. So here's what I'm...

I have the below formula which picks up the column header of the most recent date that is in a cell between N2 to Q2 and X2 to AA2 (ie not in o2 toW2). This works fine until a date in o2 is the same as N2 (providing there is no further dates in the later cells in the formula. If this happens, it...

I have managed to get to grips with creating an email and adding the text i need including leaving in the default signature. However what i need is to create 3 new macros with different text in an email but including a 4x2 table in the middle of the text. because of the number of variable...

I have a pretty complicated sheet that is calculating the average for the last 3 days, 6, 12 and 24 days. I have noticed that the answers fro 3 & 6 days are correct, but the 12 & 24 days are not correct. =AVERAGE(OFFSET(C1,0,COUNT(C2:ZY2)-3,16,3)) is correct answer...

Hi, I'm trying to use the index match function to find the result where the source (in this case the account) could be in columns A through E, and the month is in row 1. Here is my formula, I know this is not correct, anyone know how to write this correctly? Any help would be greatly...

I have a 2 sheet workbook sheet1 has 2 columns with the labels doctors and email in the top row each doctor has one email sheet 2 is a sort of a pre-arranged stationary that I need to add the doctors name and email to before they print out I have been able to create a userform with 2 comboboxes...

hello, everyone, is there any IF statement that i can use on below time range when counting start/end time and return correct or out of range? <tbody> request time given time return 09:00-18:30 09:00-18:00 correct 09:00-16:30 09:00-19:00 out of range 13:00-21:00 12:00-21:00 out of range...

Hi In this article https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas MS define SaveAs as a method!! While object browser in VBA editor define it as Sub? Which one is the correct one? or it does not matter? Thank you very much.

Hi all, I guess this is not possible in vba : MsgBox Evaluate("IIF(1=1,True,False)") Am I correct ? Thanks.

Hello all! I am trying to get the total sum of a table, which has values in different currencies (ARS, CLP and UYU). I started studying DAX last week and I was able to get the correct sum per month, but the subtotals are not working. :( Basically... I have a table with the conversion of...

I'll try and explain this the best I can I'm using a spreadsheet at work where I have created a drop down list of suburbs. It's not really what I want I want to be able to start typing a suburb and the name comes up and then just press enter when it's the correct suburb Is there a name for...