Search results

I have a list of values in Column A Column B is a helper column that groups the values together from Column A using numbers Column C is the results column that returns the average for each group of values in Column A To note, Columns A and B will be appended with new data daily. I need a...

No, closest does not necessarily mean the two previous rows. But, it does refer to proximity to the value in the given row.

I have pricing data in Columns A - B that will continue to append over time. I'm looking for the 1st and 2nd Highest or Lowest values in the column that occurs before the subject value, but closest to the subject value in the column. I identified the correct answers in Column F-G for the subject...

Yes. Indirect is indeed complicated but I managed to figure it out.

Thank you all. I've come up with this formula using Indirect that works for my needs. =INDEX(INDIRECT("'"&A8&"'!"&D8&C8&":'"&A8&"'!"&E8&C8),0,MATCH(E6,INDIRECT("'"&A8&"'!"&D8&B8&":'"&A8&"'!"&E8&B8),0))

Here is my current working formula =INDEX(AUDUSD!AF31:AUDUSD!AM31,0,MATCH(E6,AUDUSD!AF1:AUDUSD!AM1,0)) However, I need to reproduce a formula that will produce the same result with the cell references broken apart in other cells as follows: A8 - AUDUSD B8 - 1 C8 - 31 D8 - AF E8 - AM F8 - The...

Thank you. This works perfectly.

I don't believe I have MAXIF and MINIF functions in my version of excel. They did not pop up as a selection when typing in the formula bar.

I'm stumped. I need equations to solve the problem in Rows 9 and 20. The correct answers are in Rows 10 and 21. I prefer a result that does not require an array if possible. The sample excel file is also attached. Thanks for the help.

Here is a screenshot that depicts the need

Yes that sounds like what I need. I just don't know how to code it. Thank you.

By selecting I mean actually clicking the cell and selecting an option from the drop down menu.

I have two columns of Data Validation. Each for every cell consist of either blank or "X". The two column ranges are 'VA_IRRRL!R7:R33' and 'VA_IRRRL!S7:S33'. 1.) I need VBA code that prevents the user from selecting X more than once in each column. The user will have to delete the current X...

I inserted and ran the code but the contents did not clear. Am I missing something? Sub GetRS_FHA1_1() On Error GoTo ErrHand: Dim ws As Worksheet, ws2 As Worksheet Dim JsonText As String Dim Parsed As Dictionary Set ws = Sheets("Ratesheet") Set ws2 = Sheets("Ratesheet2") 'clear old...

Below is the beginning part of my code. As you see there are two sheets where I clear contents from a range of cells on "Ratesheet" and Ratesheet2". I also want to clear contents on these cells 'VA_IRRRL!R7:S33' every time the marco is run. Please advise what code should be inserted to clear...

The workbook is rather large. May you put a sample code together? I can modify once I see the correct syntax and logic.

I have a sheet called 'Clear'. Column A has the names of other sheets in the workbook. Column B has the range of cells listed like this B1, B2:B5, B10:B11, B14, B18:B22, B25, B29:B33, E25, H12:H14 for which I need to clear contents for each corresponding sheet listed in Column A. I need VBA...

I'm trying to clear the contents from cells in the following seven worksheets within my workbook. However, I get an error message: "Run-time error '13' Type mismatch". My code is below. What am I doing wrong? Sub Clear_All() Dim aRange, bRange, cRange, dRange, eRange, fRange, gRange As...

Here is an example in column A with zero as a value. So if the lookup value is 4 the formula returns 0 as the result. I have a list of numbers in column A with some duplicates : 2 5 2 7 0 8 9 7 I need to find the smallest and the lowest value to a given number preferably without using an...

Is there a way to modify the formula to disregard value equal to 0 in column A? I don't want 0 to be considered in the result.

I have a list of numbers in column A with some duplicates : 2 5 2 7 8 9 7 I need to find the smallest and the lowest value to a given number preferably without using an array. Let's say that number is 4. These two formulas will go into cells B1 and B2 respectively.

On Row 3 I have numbers as follows in columns N, O, P, Q, R, S: 0 2 0 1 5 0 I need to put these numbers in descending order on Row 4 using the same columns as follows: 5 2 1 0 0 0 The numbers will change frequently also. Thanks.

I have rows of text in Column D below that look this this. I need a formula to extract the date from the string into Column C so that excel recognizes the result as a date format. Keep in mind some of the dates will have one digit for the month and other two digits for the month as depicted...

I have raw data in one sheet called 'Raw_Data' with an alphabetical list of two letter abbreviated states in one column with corresponding counties in the adjacent column. On another sheet called 'Results' I need to select from a list of counties for just the two letter state entered by the...