Search results

Hi @Chihiro I appreciate that - that's the direction I was moving in and I'll just plan to do that as there's no issue with me creating an index column in my file. Much appreciated!

Hello all, Is it possible to return the Top X values in a Pivot Table based on a on the alphabetical order of one of the fields? For example, if you have "Last Name" in one of the Rows. And there are 1,000+ Last Names but I ONLY want the top 10 or 100 or however many last names - based on...

@vletm Perfect, thank you again!!

@vletm Amazing! That worked perfectly. Thank you so much! One question though - is there a way to do this and retain any formatting from the original list in Column A? A few names are bolded / cells are filled with a color - any way to keep that? Thanks again :)

Hi all, I'm assuming this will require VBA but please let me know if this is best posted under another Forum category. I have a long list of names in Excel (1,000+) in Column A. I need to organize them alphabetically (A to Z), but as follows: Column B Column C Column D 1st Name...

Hi @Hui, I do not. A colleague of mine used the Wizard to create the merge and now has the large document containing each set of individual documents. They’re being emailed to managers and we need the file name for each to be descriptive about what each file is. Any suggestions?

@Hui good question- we had done that but were unable to name each pdf when creating them. As we created over 250 PDFs, we thought we’d try this. Any thoughts on an easy way to split out the sheets and name them in the merge/macro?

Hi all, my apologies as this is actually being used in a .Word doc, but hoping it's okay to post it here as perhaps this is something that someone may tackle in Excel. I've created a large file using a mail merge. The large file is a combination of multiple 3pg sets of information, with each...

I changed the heading for Column D to "Percentile" and here's my final formula: =(1-(IF(ISNUMBER(C2),SUMPRODUCT(--([Level]=B2),--([Score]>C2),--ISNUMBER([Score]))+1,"")/COUNTIFS([Level],B2,[Score],"<>"&"",[Score],">"&-1)))*100 Would love to hear if anyone has a different approach!

I'm looking at the solution in more detail @bosco_yip and I don't think this gets me what I need. I'm trying to now back into these categories by: 1) Determining where each Score ranks within a Level 2) Determining the number of Scores within a Level 3) Dividing rank by number of Scores 4)...

Hi @bosco_yip , thanks so much for the quick reply. To account for the Level criteria - I was going to simply add and "IF" statement to the front of your MATCH formula. Would you agree that is the best way to do it? Thanks!

Hello all, I've read various articles about this but haven't been successful in creating something that works, so hoping you can help. I'm using Excel 2010... I'm attempting to bucket scores for a data set - based on 1 criteria ("Level") - into deciles. The challenge is that I have 20+...

@vletm, that worked! many thanks - below is my final code in case anyone is interested Private Sub Workbook_Open() For Each wks In ThisWorkbook.Worksheets(Array( _ "Sheet1", "Sheet2")) With wks .Unprotect "password" .EnableOutlining = True...

Oops, hit post too quick :) That didn't work so I figured I was doing something incorrectly...

Hi @vletm , I did. I added the following just below the ".EnableOutlining = True" .AllowFiltering = True

Hi all, I have some code that is un-protecting each worksheet in my workbook, enabling outlining (to allow users the ability to use the group/un-group functionality) and then protecting the file again. The issue, however, is that my protected sheets don't allow for the filters to be used. Any...

Perfect - @Logit thank you again for everything!

Great catch with the "Email Settings" tab. It's working better than before but when I "Send Manager Emails" - 3 emails are created in Outlook with the attachment and the body of the email as defined. The "To" field though is pulling from the InfoA field (Column E). It should pull from To...

Hi @Logit , thank you so much for your review and for isolating the error in the code. Much appreciated. Does anyone have any thoughts on how to fix this code? I'm still struggling with the fact that this is working for the test emails but not for the actual (i.e., manager) emails. Any...

Found a way to attach a sample file. Please see attached.

Hi everyone, (I've posted a sample file in the post below this one) I modified code that I found online a few years ago for a "PDF Generator" (I don't remember the author, so unable to give him/her credit...but this isn't my code) and now need to revisit it for a work project. Can anyone help...

Thanks @Chihiro - I also found some great reference material here in case it helps others: https://www.vertex42.com/.

Hi all, I came across the following chart image online and would find value in recreating this, but am at a loss on where to start. https://zebrabi.com/wp-content/uploads/2017/04/revenue-expenses-profit-loss-with-variance.png Is anyone able to suggest an online article that would help me...

Hi @NARAYANK991 , I appreciate the reply. I ended up copying my data to a normal chart and proceeding from there. Best, Dave

Hi everyone, I was inspired to follow along with a recent post by Jon Peltier: http://peltiertech.com/Excel/ChartsHowTo/PanelChart1.html I'm able to setup my pivot chart with no issues, however I am unable to add in the vertical gridlines (using dummy XY series w/ vertical error bars). This...