Hi,
I am looking for some help in finding an excel formula which will look up to manual values against a table on another sheet and give me the number in return.
For example, On sheet 1 I am looking search for the following values, Colleague name and period.
Within the table on Sheet 2 i...
I'm using the following to convert Application.Username which is formatted "Last, First" to "First Last". For my name, it is working, but for a colleague it is not. I am baffled. The result for my colleague is "h, John Smith". I have had her select all and retype it, and it's still not working...
<tbody>
Colleague
TEAM
Course id 123
Course id 124
Course id 125
Course id 126
Course id 127
Course id 128
Colleague 1
TEAM A
Successful
Successful
Successful
Successful
Successful
Successful
Colleague 2
TEAM B
In Progress
In Progress
Not Registered
Successful...
I wrote the following to remove the time from the date in a report we are provided by a vendor. When I run this macro in the US the field updates properly, but when my colleague in Europe runs the macro it returns #Value error for most of the dates. I initially thought it was just a problem...
Hi guys,
I'm currently in the process of creating a training matrix.
I designed the layout thinking I wouldn't need to go the lengths of protecting certain areas of the work sheets, but a colleague of mine has proven me wrong.
I protected the sheets not realising it would stop the groups...
Hello everyone,
Firstly, apologies if this has already been asked on here - I've had a little search around but I can't seem to find exactly what I'm looking for. I really just need an excel guru to point me in the direction of what I need to know then I can go away and find it.
So, little...
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.