Dear All,
Please Help
I receive daily 1000row of data with address merge together i have to search one by one to find particular word to the accurate address for the system to understand and the address which client gives is not accurate some merge,some with comma some without spaces.
Is...
Happy Friday everyone,
I have 2 columns of data (A-Trans and B-Reason) - each trans in col A should should have a reason in col B.
The logic I am trying to apply is:
if A3<>A2 do nothing.
if A3=A2 and B3 is blank, B3=B2
I am looking for a solution for this problem. I preferably am looking...
Dear all,
I've been making a large Excel file with lots of data and formulas. Its supposed to be a system for a specific department. I've made a sort of loading screen/splash screen when starting up where it says please wait while the program is loading. then at the same time the workbook...
Hello,
How one can achive solution in the following situation:
<tbody>
ID
STATUS
DAY1
DAY2
Day3
Day4
DAy5
H1
PASSIVE
100
100
100
H2
ACTIVE
100
500
H1
ACTIVE
100
500
200
H3
ACTIVE
100
200
500
H4
ACTIVE
100
200
500
</tbody>
After...
Hi
I have a dataset from a relational database that I ma using Excel VBA to format from one worksheet to another
I take the raw export data and depending on whether it's header or child record data I format it a certain way in the worksheet
I've two worksheets 'Export' where the Database...
Let's say I have someone enter 4 numbers in the range A1:A4. This will look as follows:
1
2
3
4
I have these numbers automatically enter the cells in a separate row. For example, the numbers go into the range D4:G4 to look as follows:
1 2 3 4
Now here's the important part. Can I have the...
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.