Re: Find Last Row in Array with Multiple Criteria
Couldn't get either to work. Thanks for your help.
Re: Find Last Row in Array with Multiple Criteria
Couldn't get either to work. Thanks for your help.
Re: Find Last Row in Array with Multiple Criteria
Thank you for your reply. I should clarify. I am looking for the value in the last row of the array where the criteria are satisfied. I am not looking for the maximum value. From my example the 500 and 200 happen to be the biggest numbers in the range, but the result could be a negative number as well.
I have a table that looks like this:
C1 C2 C3
A NY 100
A NY 250
A NY 300
A NY 400
A NY 500
B LA 60
B LA 90
B LA 120
B LA 150
B LA 180
B LA 200
I want to pull the last value in column C when the criteria match. Ie: A and NY result is 500; B and LA result is 200.
Any ideas?
Thanks
Re: Dependent Drop Down List without using dynamic ranges
Thanks marcol, works like a charm!
Herbds7 wasnt able to use yours as I am on 2003 but thanks all the same!
Hello,
I would like to create a drop down list that is dependent of the selection of another drop down list.
I know how to do this using validation and dynamic named ranges. However, is there another way to do this perhaps using a custom function or vba?
I have attached a sample sheet. The first tab is the format I am essentially looking for with a simplified source range. The problem is that my source tables are so large and ever changing that naming a new range everytime is not practical. The second tab is an example of what my source range will look like.
forum.ozgrid.com/index.php?attachment/42005/
Thanks for your help.
Hello,
I have a workbook with two sheets that monitors file receipts. On the "Tracker" sheet, I have a list of companies with their expected receive date, chasing status, and received date. If the file is not received within 3 business days of expected date, in the "Chasing Required" column the user is instructed to "Send First Chaser", if it hasn't been received after 8 business days, "Send Second Chaser", and if still not received after 13 business days, "Notify Client". I have that formula in there and it works fine, however, I need to modify the formula so that if the user enters a date in the corresponding column on the Expected Date sheet, the formula will say "1st Chaser Sent 08/08/2010", or so on. I came up with the following formula, and I cannot get the last two functions to work, probably since I went over the function limit for excel 2003.
=IF($D2<>0,"Received",
IF(TODAY()<=$B2,"Not Due",IF(VLOOKUP(A2,'Expected Date'!$A$2:$F$24,6,FALSE)<>0,
CONCATENATE("Client Notified ",TEXT(VLOOKUP(A2,'Expected Date'!$A$2:$F$24,6,FALSE),"dd/mm/yy")),
IF(NETWORKDAYS($B2,TODAY())>=13,"Notify Client",
IF(VLOOKUP(A2,'Expected Date'!$A$2:$F$24,5,FALSE)<>0,
CONCATENATE("2nd Chaser sent ",TEXT(VLOOKUP(A2,'Expected Date'!$A$2:$F$24,6,FALSE),"dd/mm/yy")),
IF(NETWORKDAYS($B2,TODAY())>=8,"Send Second Chaser",
IF(VLOOKUP(A2,'Expected Date'!$A$2:$F$24,5,FALSE)<>0,
CONCATENATE("1st Chaser sent ",TEXT(VLOOKUP(A2,'Expected Date'!$A$2:$F$24,5,FALSE),"dd/mm/yy")),
IF(NETWORKDAYS($B2,TODAY())>=3,"Send First Chaser",
"Not Due")))))))
Display More
That would probably work in 2007. Any ideas would be greatly appreciated. I have attached a sample file.
forum.ozgrid.com/index.php?attachment/32755/
Cheers
Re: Delete row is sum of values in specific columns equal zero
Yeah actually, the sheet is quite huge and it has to remain in a certain order for a data feed to pull it in. There are several thousand rows, and the uploader wont take it if the 4 middle columns in a row are all equal to zero.
Hello,
I would like to use VBA to delete an entire row if 4 of the columns in that row are ALL equal to zero.
Please see attached. The row highlighted in yellow is the example of a situation when the entire row would be deleted.
Thank you so much for your time...
Re: Find matching based on drop selection and copy cells to other sheet
Quote from AAE;512452See attached.
Thanks! Works great.
Hello,
I have 2 sheets, Inputs and Rec. The user picks a company from a drop down and enters relevant information in fields on sheet "Inputs." I would like the user to be able to click a button that says "Add Data" and have the data pasted in the corresponding cells on the sheet "Rec". After the paste, I would like the form to be cleared so that the next company can be updated. Please see attached workbook.
Thank you so much for your time...