top

Hi guys, I have attached a spreadsheet, I'm creating a report. I would like to keep it on rolling 12 months. What I would like that every month when I enter the date at the top the following should happen automatically : 1. Column 'B' removed 2. Column 'C' to 'M' move from Column 'B' 3...

Hi all, I am quite new to excel so pretty basic questions from me but I would appreciate your help. I am trying to work out how I would find the top 3 reasons for a particular month compared to another month with percentages. And if they have changed position. example. the data would be on a...

Hi, I have 3 columns... EVENT-SCORE-AVG of Top 4 I need a formula for COL C that will put the average of the TOP 4 ranked (COL B) for each EVENT in COL A Thanks Event Score Avg Of Top 4 1 131 129.00 1 129 129.00 1 129 129.00 1 127 129.00 1 126 129.00 1 124 129.00 1 124 129.00 1 123 129.00 1 0...

Hi All, please see the formula below. I obtained this formula some time ago and always use it to number cells. Id like to decipher it so instead of being 1.1, 1.2, 2.0, 2.1 etc. When I set the top level number as 000 it numbers 001, 002 or when the top level is 100 its 101, 102 etc Any...

Hi all, I have a list of of employees with a unique number assigned to each one. Then i have a separate list with the entire list of employees and their 1Up manager as well as their 2 Up manager. I need a script that will look up that employee on the list, finds their 1 UP manager, checks...

Hello, I have a list where I need to get totals on cur. basis on top of the data as per the filtered account ( A1 ) basis. I need to type a formula in between E1 and E4 in curr. basis but , I do not know how I can run subtotal with if condition. Right side of the spreadsheet ( between column...

I have a dynamic pivot table that will update as you refresh it which has been really useful. I am now looking to try and have the pivot table move as you move down the page instead of it being fixed at the top of the page. Ideally, I would want the pivot to stay at the bottom on the table it...

I have a long list of days (Monday-Sunday) I need to sort this list with the current day on top. example: today is Wednesday short the list will show Wednesday on top followed by Thursday, Friday, Saturday and so on with Tuesday on the bottom.

This issue has been causing me some angst. I need to filter data based on a string value, the value is greater than X and X potentially can be anything. Up until last week it was always 1.0E-06, so the string was >1.0E-06 ' Release Filter and select ">1.0E-06" LR2 =...

Assuming the data below starts in column A. I'm trying to write a formula in rows 1-3 that will look in Column D, find the top 3 in rank, then provide the adjacent from in columns A,B,C,E, and F. Help? <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Tiger...

I have created a pivot table and filtered it to show only the top 5 results. However, I have multiple threads of data that contain the same value and as such, the top 5 pivot table shows more than 5 results. Is there anyway to lock this to 5 only?

Hello All, I am using Power BI and applying Top N filter to show top 20 it is working but I want to show rest of the values as "other group" and also total at the bottom ? thanks

My Objective: I have a plot plan that I've figured out a scale between points and feet on. However, to make it more interactive I want it to store the positions as they are labeled so they can autopopulate as people reuse them. I realize that's vague but suffice it to say I'm real close to...

Hi, everyone. I am using the Top 10 tool in a Pivot Table, but need to exclude one of the items that is in the top ten. When I uncheck that data item in the list, it removes the Top 10 filter entirely and shows all of the data. Is there a way to manually exclude certain items from the Top 10...

Hi All, I currently have a top X formula going on. I142 is whatever number I want to put in, for example 10. I143: =IFERROR(LARGE($N$2:$N$126, $I142),"0") I144: =IFERROR(COUNTIF($N$2:$N126,">="&$I143)," ") I would like to change I144 so that when it looks at I143 and it is zero (based on the...

Hi, I am using the advanced filter with two criteria to sort a list. However, I want to use top #10 or top #25 items using auto filter. Is it possible to use top #10 with advanced filter and/or can I use auto filter on the list that I sorted using the advanced filter?

Hello. I am a football Stats man, and I have been trying to run a PowerQuery using my very limited knowledge with even more limited success! For example on this page : https://www.premierleague.com/stats/top/players/goals?se=210 I am looking for this information here: It is struggling to...

Hello, I need help please. I have a list of random dates across multiple years in cells B3:B10. I am trying to create another list in column D that looks at the list in column B and pulls out only the unique Month and Year combinations represented in the column B list. I found this formula...

I'm using Microsoft Excel 2010. It allows me to freeze the panes but it only permits either the left pane or the top pane. How do I freeze both the left-sided pane as well as the top pane? Thank you for any inputs

I have posted this before but the marco did not do what I needed. I would be so grateful if someone would help me. I process reports at my work while they are all different meaning different numbers of columns and rows of data and number of tabs etc. They each need to have three things before I...