Video How to Post a nice screen-shot with Mr.Excel HTML Maker

[GerryZ]

hello if you like to post in your threads a nice HTML screen-shot like this
whatch this YOUTUBE video and I'll show you how to Istall the ADD-IN and how to use it
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be
let me know!

Book1
	A	B	C	D	E	F	G	H	I
1		JAN	FEB	MAR	APR	MAY		41	criterio
2	Frank	11	17	30	10	9		Julia	riga
3	Joe	28	22	34	22	43		JAN	colonna
4	Anna	5	22	14	37	21
5	Julia	12	18	19	35	20
6	Anna	24	34	9	37	12
7	Julia	41	36	39	20	23
8	Anna	99	8	5	31	32
9	Frank	35	24	42	24	36
2

Cell Formulas
Range	Formula
H2	{=IF(COUNTIF($B$2:$F$9,H$1)=1,INDEX($A$2:$A$9,MIN(IF($B$2:$F$9=H$1,ROW($A$2:$A$9)-ROW($A$2)+1))),"")}
H3	{=IF(H2="","",INDEX($B$1:$F$1,MIN(IF($A$2:$A$9=$H$2,IF($B$2:$F$9=$H$1,COLUMN($B$1:$F$1)-COLUMN($B$1)+1)))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[My Aswer Is This]

Thanks for sharing this.

 

[hiker95]

GerryZ,

Nice done - thank you.

 

[GerryZ]

Hello every body
I'm glad you like this video
it would be interesting if many of us put the link of this video on the signature so as to disclose as much as possible
thank so much

 

[Caribeiro77]

I already tried once to install this add in with no success....Today, after watching your video i tried again......and again with no success...Don't know why i'm not being able to install this.....

 

[GerryZ]

Hello Caribeiro77
did you follow all the steps of my video?
maybe something that i didn't Expalin well?
Which Excel version do you have?
You MAC or PC?
I' m interest to know what is the issue
I hope somebody that had the same problem of Caribeiro77 can help us
thank you

 

[Caribeiro77]

Gerry you've explained everything nicely..... i have PC ( windows 7) and Excel 2013 just like you, i followed your video step by step and............nothing.....

 

[Caribeiro77]

Hey Gerry i managed to make the add in to work, i uncheked all the other add-ins i have and also had to delete one in particular that i had, a Formula Translator add in, and after doing all this, the Mr Excel HTML maker, finally works....

 

[GerryZ]

hello caribeiro77
I'm thinking that you probably have istalled this new Add-In but probably you don't see it
I mean that you need to activate innthe ribbon what you allready have istalled in your computer
Try this steps:
1) file
2) Option
3) Customize Ribbon
4) now you need to check-mark the DEVELOPER TABS
let me know!

 

[GerryZ]

@ Caraibero77!!!
hhhhhooooo!
I'm so glad it works
waiting to see your first HTML screen-shot!
adeus por agora