### 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.

#### 15 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...
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...
Neha Sharma said...
Mobile app development company in Mumbai said...

Mobile app development company in mumbai