Hi,
I have a column of date windows formatted as "mm/dd--mm/dd" (so, not in an actual "date" format recognizable by Excel), and I want to use a helper cell to pull the first two numbers from that column, and then another column to pull that number, and return it in "mmm" format.
For example...
Hi all,
I am trying to find the way to obtain the minimum value from a range, with some conditions.
So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...
Hello and help!
I am trying to set up a conditional formatting formula that highlights similar values in the same column (Column U) listed more than 2 times. The issue is that I need the formula to only match the text before the "/" character, since the number will always be unique.
Example...
Hi all,
I have a lot of cells that look like this:
Now, what I would like, is to have a formula that returns ONLY the top part of cell A3
I have separated the texts by pressing ALT + ENTER and then typing:
Test 1
Test 2
Test 3
instead of
Test 1 Test 2 Test 3
Is there a way in which I...
Hi all,
I am currently trying out this formula:
Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!")
Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...
Hi all,
I currently have a very large data sheet that looks like this:
In this example, I've just put in a format of: Date,Name,Gender
Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc.
My ideal format would be: Date,Name,Gender...
Hi all,
I am currently working with a data set that looks like this:
I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this
So the result should be like this:
Does anybody have a formula for this?
It would be greatly...
Hi all.
I'm attempting match col A with embedded name on column E.
so far i have extracted the match, but I want to add up all the values pertaining to the hardcoded list in A:A.
also the number after the name is always one space apart from the end of the name. like "dsgdf 100"
See below...
Hello - Trying to come up with formula that will give me the number from a different cell, but the cell I am trying to reference also had letters,
Example: The cell referenced, lets call it A1, contains: '4 yrs'. I would like cell A2 to calculate 4. I tried doing a =LEFT(A1,1), but the issue I...
I am wondering if someone can help assemble a formula. I have a rota and wish to count the amount of people on night shift. Easy enough to separate and total them with a "countif" however, when people mobilise, instead of the usual "NS" for nightshift or "1" for Day shift, we now have the...
Hi!
I have the formula COUNTIFS(INDIRECT("'"&$E12&"'!$I:$I");"A*")
but instead of A* (to say that it should select the values that start with that) I want to put a cell (f4) which says A.
How can I do that? Thank you very much
I'm looking for some VBA to extract the text: 1620011017 from the below string;
Inv_1620056384_1620011017_1034258
There could be any number of characters, so I think I would need to define it based on the fact it's the string between the 2 underscores.
I think starting from the right of the...
I need excel formulas that will help me differentiate each piece of these cells. Here are examples of the cells
Elephant12-8Wb
CAT193-45M
I already have the formula to get Elephant and CAT on their own. But then I need formulas to get 12 and 193, 8 and 45, and Wb and M on their own.
Thank you...
I have the following column with dates, that I need to convert for excel to recognize them as dates:
21/02/12 15:34
21/02/15 21:18
21/02/17 22:06
21/02/15 21:37
21/02/15 16:05
21/02/17 20:53
21/02/17 00:55
21/02/17 02:34
21/02/19 05:31
I have tried using DATEVALUE, TEXT...
Hi guys! Long time reader, first time poster.
Getting very frustrated with my VBA so any help is appreciated.
In my worksheet "Paste Data", I have a string of text in column G and need to use the LEFT formula to find and copy the text before the character " - " into column H.
My VBA code...
ISO VBA command to insert a dash (hyphen) as the 5th character from the left, and 6th character from the right, in a string of varying length, within an array.
For example...
Column Z contains the following list of values:
MSEAVIMA0013S
MSEAVIRM0016S
MOLPVIRM0017S
MOLS130012S
MSEAVIRM0011S...
Hello all,
I've got a problem with a table I set up.
Here is the reference table:
2019-20
2018-19
2017-18
2016-17
2015-16
2014-15
2013-14
2012-13
2011-12
2010-11
2009-10
2008-09
Division #
Div Name
Division OH
Division OH
Division OH
Division OH
Division OH
Division OH
Division OH...
I have the code below that works. It searches column A looking for "00" as the left most characters and then formats that cell with white text and black interior.
Dim cel As Range
For Each cel In Range("A6:A300")
If Left(cel.Value, 2) = "00" Then
cel.Font.Color = vbWhite
cel.Interior.Color =...
I have a string of text in Google Sheets - I would assume is the same formula
I can get the first 2 words - but not sure how to expand to get 3rd +
In Cell F2 I have typed: (no bold)
Wall panels for interior wall
FIRST WORD
=LEFT(F2; SEARCH(" ";F2;1)-1)
SECOND WORD
=MID(F2; SEARCH(" ";F2) +...
Hi Folks,
I know this has been asked a thousand times and I'm trying to implement some of the solutions I've found but I just can't seem to get this to work. I have values in column I that four decimal places deep and I simply want to remove the last two characters. The problem I'm noticing...
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.