top

I'm looking to find a way whether it be in excel, power query, power BI or Pivot to display the top 20% of customer sales per agent without the need to create a Top 20% Conditional Format for each agent and for each update. Agent/Cust is a concatenation of the agent name and customer number...

Hi there, I’m trying to separate style and color. My file has products like ABC top in red ACF bottoms in green A C B top in blue I need to extract ABC,ACF and A C B in these examples. Can you help think of a formula that helps? Thanks a lot!! Chris

Hello, I have a data set that is updated weekly. Multiple pivot tables/charts are outputted on a separate worksheet showing Top 5 or Top 10 jurisdictions, people, practice groups, etc. with the corresponding fees. The pivot tables/charts are already filtered by one of two main clients. However...

Good Morning- Quick question for someone- I've got numbers A1:A10 a "Y" or "N" in B1:B10 a "Y" or "N" in C1:C10 I'm trying to put a rank formula together that IF B cell is a "Y", it goes to the top of the rank, irregardless of the number in A cell. Then if C cell is a "Y", it goes to the...

Hi there, I have a pivot table where I want to filter the top 10 value (gap of 2019 vs 2018) and I am not able to do it properly due to mix of positive and negative value. If I use the Value Filters --> Top 10, I get the top 10 absolute value, but I want only the positive one. I will get so far...

Hello all I have this short line of code that removes duplicates rows based on the cell values in column "A" This works fine but I need to delete from row "A" downwards instead of last row upwards b = Cells(Rows.Count, 1).End(xlUp).Row Range("A1:Z" & b).RemoveDuplicates Columns:=1...

I have this formula: =IF(ISNUMBER(SEARCH("I",I35)),"1",IF(ISNUMBER(SEARCH("II",I35)),"2",IF(ISNUMBER(SEARCH("III",I35)),"3"))) my results keep coming back with a 1 this is the text i am interrogating: (assume the top cell is I35) <colgroup><col></colgroup><tbody> MB7603(I) MB7603(II)...

I need to create a pivot table. My headings are in A3 toAE3, and the data is in A4:AE462. Here is the problem; at the end of the table I have headingthat repeated, <tbody> 3900 3910 3940 3980 TOTAL </tbody> Three times and thenand there is another heading on...

Hey, I am a novice when it comes to using ActiveX Control and VBA to build macros but I am having incredible difficulty getting something simple to work. I want to build a macro which hides and unhides 3 columns in my excel sheet however when I run the macro it unhides unwanted columns and...

I have roughly two thousand entries in two workbooks that I need to reorder in number and date sequence, I have no idea how to do this, filter only displays the information in whatever fashion rather than actually reorganizing it. The end result needs to be each entry in a date range needs to be...

Hi! I am trying to determine the "white space" between the last used row and the last row in print area. I currently have this to determine last used row and it works, but can't determine last row in print area. Sub cover() Dim lastrow as long Dim top as string Lastrow = range("A" &...

Howdy, I need a UDF to return the nth value from a row or a column. Ex. I want the 4th item (from left to right) in range A2: P2 or I want the 5th item (top to down) from range A2: A16 If it were not very complicated, it would be perfect if I had the choice of the opposite, ie from right to...

Okay, so the context is that I'm trying to model the running of an e-wallet, where users are able to top up. So basic assumptions: 1. Average top up value ($): D 2. Average top up frequency (top up every X months): T Figures input a. Operational month, O : 0 1 2 3 4 5 ... b. New users that...

Greetings, I have a head scratcher that I am hoping you all can help me with. I am using an Excel worksheet on a 42" touch screen monitor as an information screen in our lobby. The WS is set at full screen and automatically updates with information on a regular basis, and visitors can also...

I want to create an archive of all my workbooks that are in the top folder and subfolders in one go (all the information must be presented as a values, therefore no formula). - Top folder contains multiple subfolders and some workbooks. - Each subfolder contains multiple sub-subfolders and some...

My Excel workbook is set to open to the form and hide the workbook, in order to view the work book you must type "view" in the top text box and hit the "check out" button. When hitting the "X" in the top, right corner of the form it is supposed to close the unload the for and exit the...

I really need help on this. So the idea is that I'm running a calculation of top-ups to an eWallet, so I have a. Average top up amount ($47.50, b7) b. Average top up frequency (once every X months, b8) c. Number of new users (varies each month, row19) d. Attrition rate (varies each month) e...

I have 2 tabs: 1. One is a large data sheet that has a bunch of client names and amounts (note for example like Google can appear more than once, so I would need the total amount, etc). 2. The second tab is a top sheet that I've been manually summing the top 20 clients, removing duplicates...

Hi, I would like to find the top 3 most common numbers within column D using Marco and display the result on the side. Start counting from D6 all the way till the bottom. (There could be 1000+ rows). Thank you. Display the following on the side 1st most common : XX 2nd most common: XX 3rd most...

I have a sheet that when I enter the letter B in column A I need the top border for that row to be bold from column A to column AL. Thanks for your help as always.