Contacts

You can contact me by email at: jpgpinto (at) gmail (dot) com

Would like to hear from you. If you have some comments or sugestions about this blog, feel free to send me an email. I'll try to answer as soon as possible.

21 comentários:

Parcsyde said...

Excel 2010
Dealing with Worksheets

I am trying to find a way to calculate the total number of "worksheets" within a Excel file. I want the number to be placed into a cell on one of the worksheets. My Excel would be something with multiple worksheets, and 2-3 of them would not be someting I want as part of my count, so I believe if I can just find out the total I could than subtract 2 or 3 from it to get my total worksheets that I am interested in.
Do you know how I can do this? Via a function in a cell or by VBA?

Thank you for your time,
Doug from New York

jppinto said...

Try this custom function. Use in any cell like

=SheetCount() for all Sheets

=SheetCount(True) for Worksheets only

VB:
Function SheetCount(Optional Worksheets_only As Boolean) As Long

If Worksheets_only = True Then
SheetCount = Worksheets.Count
Else
SheetCount = Sheets.Count
End If

End Function

Anonymous said...

Hello Mr. jppinto,

Thank you for you helpful blog.

I would ask if have an acount on twitter to teel us about your new post or send it by email.


Thank you,
Shroog

jppinto said...

Hello,

Don't have a Twitter account.

Regards,

João Pinto

Mani said...

Hi Blogger ,

I Want to Know that there is any Formula is There for Adding Auto Number after two blank Rows .
For Best Understanding i have given a link of image ..

Image Preview :- http://s2.postimage.org/k509mbfhl/sshot_1.png

As you have noted the numbers are on the url cells after two blank cells ..like that i want the forumal to enter it auto..Thank You in Advance ..

jppinto said...

This could be done only with VBA code.

Harris_AA said...

Harris_AA said...
Dear JPPINTO

Your VB-code for combining sheets of workbook is much useful. (http://www.excel-user.com/2009/10/vba-combine-sheets-data-into-one-sheet.html)
, but How do I copy and paste the values in cells instead of present one which copy the formula too.
Plz reply.

Anonymous said...

Hi there I'm not sure how to create a new thread just yet.... If you can tell me how I would appreciate it.

Also, I have a problem. I have a list of text and I am using blood up to return a value. How do I get it to return all values that are larger than another value?

Anonymous said...

I mean vlookup not blood!

Anonymous said...

Hello jppinto,

I like most of what you wrote in this blog post: http://blogs.office.com/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas/ . But one of the formulas is, I think, incorrect.

It's =INDEX(C3:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*ROW(C3:C13)),0) in the example about "You would be looking for the Name “James Atkinson” where the Qty is 1...", which returns the right value, but would not be right if cell values change. It should instead be =INDEX(C1:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*ROW(C3:C13)),0) since the SUMPRODUCT(...) returns 4 and the index formula shows the value of C6, instead of C4.

Am I right in my reasoning and if so would you be able to change the post? (I can't find contact info for Emily Warn, the blog owner) The blog post shows up in the top of google results when looking for multiple criteria lookups.

Neha Sharma said...


Rice Bags Manufacturers
Pouch Manufacturers
wall putty bag manufacturers
fertilizer bag manufacturers
Lyrics with music

Neha Sharma said...

we have provide the best ppc service.
ppc company in gurgaon
website designing company in Gurgaon
PPC company in Noida
seo company in gurgaon
PPC company in Mumbai
PPC company in Chandigarh

Neha Sharma said...

we have provide the best fridge repair service.
fridge repair in faridabad
Videocon Fridge Repair in Faridabad
Whirlpool Fridge Repair in Faridabad
Hitachi Fridge Repair In Faridabad
Washing Machine Repair in Noida
godrej washing machine repair in noida
whirlpool Washing Machine Repair in Noida
IFB washing Machine Repair in Noida
LG Washing Machine Repair in Noida

Neha Sharma said...

iso certification in noida
iso certification in delhi
ce certification in delhi
iso 14001 certification in delhi
iso 22000 certification in delhi
ISO Consultant in Delhi
iso certification services in delhi
iso certification in faridabad
ISO 9001 Certification in Noida
website designing services
SEO Service Consultant

Pradeep Appslure said...

Mobile app development company in mumbai

Raj Maan said...

1movies.pictures

Anonymous said...

I seriously love your website.. Very nice colors & theme. Did you make this site yourself? Please reply back as I’m attempting to create my own personal website and want to learn where you got this from or what the theme is named. Kudos! KBC Winner List

tech zone said...

Thanks for your great information. putlocker

Anonymous said...

Who wants to be a KBC Winner for 2020 Season ? Hurry up and avail the opportunity to become a kbc winner by participating in kbc show to answer easy general knowledge question to check Jio Kbc Winner List 2020.

Ramesh ji said...

Thanks for provide great informatic and looking beautiful blog, really nice required information & the things i never imagined and i would request, wright more blog and blog post like that for us. Thanks you once agian
we offer services birth certificate in delhi
which inculde name add in birth certificate and
birth certificate correction complete process is online and we offer
birth certificate apply online and we offer this birth certificate online same service offers at yourdoorstep at birth certificate in ghaziabad
our dream to provide birth certificate in india and other staes like

birth certificate in bengaluru and
birth certificate in gurgaon book service with us birth certificate in noida also, service at yoursdoorstep only birth certificate in india or

kenwood said...

Businesses should be aware that Salesforce can be a very useful CRM tool for their enterprise environments provided proper considerations and external help is sought for Salesforce Implementation in to their business. Salesforce training in Hyderabad