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

GerryZ

Well-known Member
Joined
Jul 4, 2014
Messages
1,224
Office Version
  1. 365
Platform
  1. Windows
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
ABCDEFGHI
1JANFEBMARAPRMAY41criterio
2Frank111730109Juliariga
3Joe2822342243JANcolonna
4Anna522143721
5Julia1218193520
6Anna243493712
7Julia4136392023
8Anna99853132
9Frank3524422436
2
Cell Formulas
RangeFormula
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.
 
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
 
Upvote 0
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..... :confused::confused:
 
Upvote 0
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
 
Upvote 0
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.....
 
Upvote 0
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....
 
Upvote 0
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!
 
Upvote 0
@ Caraibero77!!!
hhhhhooooo!
I'm so glad it works
waiting to see your first HTML screen-shot!
adeus por agora
 
Upvote 0

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