HI,
I'm trying to do the Median equivalent of AVERAGEIF(A1:A10,"*"&C12"&*",B1:B10) where Column C has text some of which is contained within a longer string in Column A and Column B has numerical values that I want to find the median of.
I found other threads where this was possible with the...
The situation is as follows:
I have a "main table" which is *full* of data. Im talkin abut 1500 entries. Then i have another table, which is for filtering. I have already figured out how to filter the table for what im looking at.
But what i now need is a way to search for a selected value...
Hello, I was looking for various solutions on the Internet, but I didn't find anything that could help me. So here's the code:
Private Sub TextBox1_Change()
Dim foundRng As Range
Set haslo = TextBox1
Set foundRng = Range("D3:D19").Find(haslo)
If foundRng Is Nothing Then...
I am in VBA H**L right now.
Here is what I need the Search Loop to do.
In Column A cell "A2" is a changing value depending on the person selected. This is basically a RecordId column.
Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain...
Hi guys!
I'm importing PDF-files into Excel in Office365 environment, using PowerQuery's new-ish PDF file support. However, given there are some minor differences over files, PowerQuery / Excel parses data a bit differently, based on individual PDF.
I'm counting on the number of imported rows...
Hi hope someone can help I have a vba that is working really well but i need to modify it slightly, currently it’s searching dependent on the value of a cell,
searchvalue = reportsheet.Range (”C2”) .Value
this works fine if the content in “C2” is exactly right, but I’m using for ref numbers...
With below formula I am counting unique values. Everything worked well until I added the dates. Any suggestions to solve this? Picture attached
=SUM(--(FREQUENCY(IF((N:N="Installer/Contractor")*(ISNUMBER(SEARCH("|"&I:I&"|";"|Visit|Online Meeting|Webinar|Join Visit|")))*(ISNUMBER(SEARCH("Ole...
Hi!
I'm trying to trying to automate a lookup process in VBA, but I can't really get it to work. Would really appreciate if anyone could help me with this. So, here's what I'm trying to do:
I want to automatically populate cell F4 with a number wich is in the first part of a string on a...
Hello,
This is my first post so please go easy on me!! I have an excel file that allows me to enter in data in 2 cells and return any matching values, it works great but when it returns the data it is not returning the cell color.
So when a cell matches it should bring back the content and...
So I have data in a column that is delimited by spaces. It would be simple to delimit by the spaces to get the desired result but the data is not as you can see below:
5pt 3rb 1st 1bl 1-2fg 3-4ft
0pt 5rb 1as 3bl 1to 0-3fg
4pt 5rb 2bl 2-8fg
If I delimited by space, I would have st...
hi good day/evening,
I am new to this forums and I want to thank everyone in advance,
can someone help me with my array problem, I wan to be able to compare a cell on a list. with this formula
COLUMN C is the list
APPLE
BANANA
STRAWBERRY
PINEAPPLE
ORANGE
COLUMN D is the what i...
Hi,
I need some help please. How do I search the entire active worksheet for a particular word, say "XYZ", remove/delete a text contains "XYZ" and be able to shift the remain of the values in that row one cell over to the left?
A1 A2 A3 A4 A5
XYZ B1 B2 B3 B4
Result...
Hello,
I'm relatively new to more complex nested formulas in Excel (Windows, 2016) and would appreciate some assistance. I’m trying to add a condition to an existing formula that currently performs vlookups based on the text of another cell (H3); the new condition that says if cell H2 contains...
Hi Everyone, I've created a listbox search function in VBA that will list products based on the assigned description in my database. My current code will work for only consecutive words, but I would like to be able to generate results regardless of order.
For example, the current code will...
Hi Can someone help me with below with formula or VBA code.
I have string in column T and I need below to be done in column AK.
If string in column T contains 07X OR 18X then publish Yes in "AK". If column "T" has 08X OR 04X OR 07A the publish NO in "AK". else publish as Others. Thank you in...
Hi everyone,
I have a question I'm not sure if excel is able to do. If I have a list of businesses in excel and want to search the web (probably google) for their website address. Is there a formula or a way to upload my list somewhere and have each business googled and return their website...
Hi guys, I'm trying to insert a formula in my code which works in the sheet but not in vba. Running the code below returns a syntax error. I noticed that the errors are due to SEARCH strings containing paratheses for "ENO=" and ",SUB". I've tried changing the paratheses to CHR(34) as well but...
https://www.mrexcel.com/board/threads/find-the-1st-2nd-3rd-common-text-w-criteria.1146002/
https://www.mrexcel.com/board/threads/top-10-most-common-text.1145758/
I don't think this is possible with just formulas but let's say I have 10 cells, and I want to find the top 5 most common words...
Hello - I spent the past hour or so searching google and the forums. I can't find exactly what I'm looking for and that's probably because I don't know exactly what I'm looking for.
My real goal is to find and highlight cells that did not get summed up. I.e. if I have a sumifs formula with a...
Hello,
I'm trying to apply a set of comments from column F to column B. I'm unable to change the formatting of column A unfortunately. It would be preferable to have a Vlookup function in column B.
Column A will always be variable in length, and column E should always contain the remaining...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.