Hello I have a lot of messages (300 approx) between myself and my bank that span a 1-2 year period.
I want to enter all these messages into some sort of timeline, chart.
That starts from the first message and progresses thru to the last message.
I guess some sort of excel flowchart, or message...
I need some help filtering out cells that a formula returns as "". I want to organize my cells so that cells that a formula returns data to is at the top and there are no empty "" cells above.
The following is how my sheet looks:
and I am using match/index formulas to return the values I want...
Hi,
I have different groups in my ribbon. I organise them one after another using
</group>
<group id="GPNOutlook"
insertAfterMso="GroupEditingExcel">
<button id="BtOutlook"
but is there a way to get this last group placed completely to the right of...
Hi All,
I require some extracting and correlating data.
In my raw data i have a PA1 followed by a PA6
<tbody>
PA1*7*-1*Item one
PA6*81001234*Item one
I require the "7" and the "81001234" to be returned in specific places in a table so i can then do a look up against them.
One thing to...
Hi folks, i'm trying to get to a stage where i can do a vlook up and the simplest way i can think of is to organise the column information from column to row, so i have only one entry for each person, although i need the row value also to be sorted lowest value on the left. is this possible...
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.