Hi,
Please would you be able to help with a formula.
I am trying to bring back the correct result as follows.
1 2 3 4 5 6 7 8 9 10 11 12
Consultancy 10000 10000 5000 6000...
The table I have below is a list of consultant details.
<tbody>
Consultancy Name
Consultant
Email Address
Phone Number
Consultancy 1
Mr Smith
smith@cons.com
020 155 6500
Consultancy 1
Ms Wright
wright@cons.com
020 155 6501
Consultancy 2
Mr Dunbar
dunbar@cons.com
020 155 6502...
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.