I have a following table.
Name
Value
X
10
Y
20
Z
30
X
40
Y
50
Z
60
X
10
Y
60
I wish to extract all the unique values corresponding to the name in separate columns. The output shall come out like this. Since X has 10 as a value twice, I want it to be considered only once...
Hello Gurus,
Hope all is well.
Could you possibly help be on how to code this?
1. In Sheet1, I need to highlight in yellow the text containing "Target" in column AZ.
2. Separate the data with "Target" text by adding a blank column
3. Add message box noting how many "Target" text are there...
Hello!
Below is my data and the accompanying graph. I've looked across forums (including MrExcel), YouTube, and MSFT help pages and I can't seem to figure out how to separate the stacked column 'ANZ' data from the 'APAC' data. I DO NOT WANT TO HAVE ALL THE DATA STACKED IN THE QUARTER!!!
My...
Hi Team,
Hope anyone can help me, I have column heading fields like New, Old, Exist, Duplicate and each column has its own values and require vba code to get each line separately. For example for product A, if you have value in New and Duplicate amounting $1000 and $2000 respectively then it...
Hello,
I have a question that i am trying my best to ask. I want to be able to find a SINGLE Value across a range of columns.
The best way i can explain this is I have a value of "ABC7190612" in a cell.
I need to find ABC in the "Product" Column
I need to find 7 in the "Year" Column
I need...
Using Excel 2016, I would like to use a pivot table that groups by date into monthly columns (this part is easy), though months from different years should be in different columns (this part I can't figure out).
My current pivot table summarises a few thousand financial transactions and groups...
Hi All, First post and couldn't find an answer with the exact solution.
I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth.
Here is a small example of the data I...
Hi All, First post and couldn't find an answer with the exact solution.
I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth.
Here is a small example of the data I...
Hi Friends
I Want To Split Or Separate The Values In Different Columns In Excel.
I Am New To Excel. Don't Know How To Separate Values From Webpage With Same Class Names.
div class="result">
<div>
<ul class="result__details">
<li>
<p class="result__label">Mango</p>
<p>Kesar</p>
</li>
<li>
<p...
How do I separate the Fund Name, Ticker and Net Flows in this list, which are currently in one column, into three separate columns with Excel 2003? I got it from this site, ETF Fund Flows Tool - IndexUniverse.com, and wanted to reproduce it for a newspaper publication.
I couldn't find an...
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.