Hello Guys,
I have below data that I need to group based on criteria below:
Raw (Sheet1):
<tbody>
ID
Name
Status
01
Donna
Done
05
Karl
Complete
06
Ems
Pending
02
Shawn
Incomplete
05
Mae
03
Ann
OK
</tbody>
End Result:
<tbody>
ID
Name
Status
01
Donna
Done
03
Ann
OK
05...
Hi All,
I hope anyone can help me with below request...
I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number.
Example Data...
Had no Idea how to title this, so to start with if anyone has a better title please help me out. New to Mr.Excel and hoping someone knows what I'm attempting to do. I am trying separate a specific number of rows in multiple columns to match another set of data with a greater number of rows. So I...
Hi,
Hopefully someone can help me with a problem I can't seem to get my head around.
Here's an example sheet: http://i.imgur.com/QWnpSLM.png
I type names into A2:A8 and use VLOOKUP to fill B2:B8 with codes from H2:H10, so far so good. But then I'd like to generate a table in D2:E8 which lists...
Hi,
A sample spreadsheet of what I have is provided below:
<tbody>
ID NUMBER
CHEMICAL NAME
HAZARD
VALUE
1
chemical a
carcinogen
recognized
1
chemical a
Respiratory, blood, kidney
suspected
2
chemical b
immunotoxic, carcinogen
suspected
3
chemical c
liver, carcinogen
recognized
4...
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.