Search results

This was exactly what I was looking for. Thank you so much!

This was helpful thank you!

Hi all. I am struggling to come up with a way to do this. I am assuming INDEX may be involved but not 100 percent sure how to pull it off. Basically, I want to check cell "C2" in worksheet "Driver" and based on what the value in cell "C2" is check range "B3:W3" in worksheet "Testing" and for a...

Hi all, I am struggling a bit to come up with a solution here. I would like to have a column that just lists the top 10 most frequent text entries from another column. Ideally I would like to do this as a formula as macros are not supported on the online excel version. I have tried the...

This worked perfect. Thank you so much for your support. I hope you have a great day and a fantastic weekend!

This worked exactly as I wanted it to. You are an absolute life saver, thank you so much. To follow-up, lets say I wanted the next value below that cell now. How could I go about modifying the formula to do so. For example, I have four values I would ultimately like to copy into a column in my...

Hi All, I am struggling with finding the best way to set up this formula in Excel. Essentially what I want to do is to check the left 2 characters in cell B28 of my worksheet titled "Data" and see if there are any matches with values in range B1:AH1 of my worksheet titled "Calculations", and...

Hi, That was just an example of how I want the values to paste. So for example, 1a is selected as "Y" in the "Driver" worksheet so I would want it to take the values found under the header "1a" in the "Calculations" worksheet and paste those four values in the "Test" worksheet. Hopefully this...

Hi All! I am struggling to build functional code to essentially check range B2:B34 in worksheet "Driver" for any "Y" value and then check the left value, for example "1a" then check if any headers match in the "Calculations" worksheet and paste the four values below that header to a worksheet...

Hi! First of all, I want to say thank you for the tips. So essentially, I want a user to specify which indicators they want measured by stating "Y" or "N" in column "B" on my "Driver" worksheet, then, I want any indicator columns that are not specified as "Y" to be hidden. So basically, I need...

Hi All! I will preface this by saying that I am fairly new to using VBA in excel. Essentially, my goal is to have a user input what "indicators" they would like to see data for, and then hide the other data that they do not specify they would like to see. I don't even know how I would go about...

Hi All! I have tried so many things at this point I think my brain is entirely fried. I am trying to find out how to check if a value matches a stated value in a formula and then counts the values in the same row it was found. This will be made more clear by looking at the attached image...

Hi! Attached is the DB w/ bogus data. Let me know if there is anything else you need. The query I am trying to use to filter data is called "qry_Srch".

Hi! First of all I just want to say thank you so much for all of the great and informative information you have provided me. Going to spend some time brushing up on things. I will make a copy DB and send it as soon as I can with bogus data in the fields as it currently houses sensitive...

So I want to be able to have information still shown if the user does not actually select anything from the list. The reason for this is because I have a bunch of different filtering comboboxes/listboxes etc. that the user can choose from to limit data as they see fit. What would you suggest the...

Hi All, So I am unsure how I should start this question off, but I am having trouble with handling null values from a listbox. I want the query to check what value is stored in the lsitbox and then only show results for that value. In the past I have used a "janky" method as seen here: Like "*"...

Thank you for this! It worked! Have a great day!

Good info thank you for this.

Hi All! I am struggling to find a way to do this. Essentially I want a query to figure out what is in two textboxes on a form and display only the data that occurs between those two values. In this case between two years as seen in the attached image below. Likely something using the Between...

This worked great thank you so much for the help! I hope you have a great day!