Is there a way I can post the cell's with formlas here or do I have to submit a image?

Wayne_Sadler

Board Regular
Joined
Jan 7, 2005
Messages
148
Hi everyone

Can some please advise the best way to submit here, the cells and formulas that I am playing with at the moment.

Many thanks Wayne
 
click the link at the bottom of my sig, download that and you can copy cell values and formulas from excel and paste them into your posts on this site.
 
If you use the "Board HTML Maker" you will be able to post your data like below:

Excel 2007
ABCDEFGHIJ
1WordsRangeDurationTotal DurationCell Address of Answers
22105300-69930050147350$G$2
31330700-20997006079800$G$3
436182100-3199210070289440$G$4
551503200-4999320080463500$G$5
6>5000500090
Sheet1

Worksheet Formulas
CellFormula
G2=LOOKUP($A2,$D$2:$D$6,$E$2:$E$6)*A2
G3=LOOKUP($A3,$D$2:$D$6,$E$2:$E$6)*A3
G4=LOOKUP($A4,$D$2:$D$6,$E$2:$E$6)*A4
G5=LOOKUP($A5,$D$2:$D$6,$E$2:$E$6)*A5

Array Formulas
CellFormula
J2{=CELL("address",INDEX($G$2:$G$5,MATCH(G2,$G$2:$G$5,0)))}
J3{=CELL("address",INDEX($G$2:$G$5,MATCH(G3,$G$2:$G$5,0)))}
J4{=CELL("address",INDEX($G$2:$G$5,MATCH(G4,$G$2:$G$5,0)))}
J5{=CELL("address",INDEX($G$2:$G$5,MATCH(G5,$G$2:$G$5,0)))}
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself
 
Last edited:
DeusXv

It does not seem to be opening as I thought and I am reading the readme.doc which says I need to add a standard .xla add-in file where do I find this file as it's not located in the online DIR
 
Download the Zip file and in it there will be a word and an excel file, take the excel file and add it to your add-ins folder,

Which for me at work is found in: C:\Documents and Settings\macfari\Application Data\Microsoft\AddIns

Then open excel and click the excel button (Top left) > Then Excel options > Add-Ins > Go > Put a tick next to "HTML Maker"

and then highlight the cells you want to link > Add-Ins Tab > Select the option you want

Hope this helps
 

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

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.
Go back
Back
Top