small

I have a spreadsheet with 18 columns and 8150 rows of data of all sales for the month. I want to extract data from 11 of those columns in to another spreadsheet based on the match in one column "sales person" there will be multiple matches (rows) and I need them all on the new spreadsheet to...

Hi guys, I have an excel sheet that is about 10 rows by 50 columns, so its very wide, but not long. Can someone advice me how to save this such that it doesnt look too small? I've tried breaking it into 5-10 pages but it still looks too small as a pdf! Is it possible for me to save it as...

Guys, So I'm using and index, small, row formula to find the nth occurrence of a result. I'm using the below formula to concatenate the results. {=CONCATENATE(INDEX(Table7[REPAIR NEEDED],SMALL(IF(Table7[ACTION]=$A$22,ROW(Table7[ACTION])-ROW(E24),""),1)),INDEX(Table7[REPAIR...

Hi all I have a recurring need to convert a large number values that come in from another system and it would be helpful to be able to do this by way of a small macro. What I would like if possible is for a macro to run on a range of cells selected by me at run time and then convert all of the...

I have a column of numbers I want to rank large to small. Large(E4:E37,1), etc..... but I'm getting a #NUM error. The cells I am ranking are linked to another tab in the workbook. In other words, it says 28% in Cell C3 . . . but what's in the cell is not 28% but the cell in another tab...

As the title says I need to do a nth value/occurrence look up. I was able to find a maximum value by using MAX in conjunction with SUMPRODUCT and thought I could apply the same logic by using SMALL along with SUMPRODUCT. My test sheet is set up as follows: A3:A17 contains letters which are A, B...

Hello all, i have a small xlsb file- 1.3 Mb that works just fine until i try to save it- then it blocks for about 5 minutes and i dont understand why. Can u help me with some advices? Thank you!

Hi all, I have a macro whhich splits the master file into small files (named as breaking files).. how do i write a code to delete macro after 01/22/2019 within exiting code for breaking into small files? Thanks a lot for your help!

RE: https://www.mrexcel.com/forum/excel-questions/1021341-vba-merge-duplicate-rows-sum-values-certain-column.html Tried the code here but doesn't seem to work well for my case. Example: <tbody> Room Quantity Description Small -- 2101 Small 1 Apple Small 1 Orange Small 2 Pear...

Hi Excel Guru's! I have one that I'm stuck on and hoping someone might be able to assist with.. Context: I'm building a budget workbook, comprised of an overview and transaction sheet, the layout for which is below. The transaction sheet is just a dump of my bank transactions and then I use...

What is wrong with this formula? {=SUM(--(FREQUENCY(IF((LocalHistory[Date]<=EOMONTH(NOW(),-48)),MATCH(LocalHistory[Talk Number In],LocalHistory[Talk Number In],0)),ROW(LocalHistory[Talk Number In])-ROW($A$2)+1)>0))} It refers to an XL table named LocalHistory of which the below is a small...

​Hi, i would like to combine SUMIF with SMALL but has some problems doing so: I have a table where Week/Year is stored and now i need to create a Top 10 of the worst results for each week. I can easily do it with the whole data set by using =SMALL(Tabel1[Percentage];Oversigt_!A3), but i can...

Good day Excel Guru's I have been trying to achieve the following with no success, I have tried using SUMIF with SUMPRODUCT but I have not been successful. I would greatly appreciate any guidance on the problem I am trying to solve. In Summary I am trying to workout number of boxes per pallet...

Dear Experts, I have multiple rows with dates, mostly with duplicates results. Suppose there are 7 entries of 3-11-2018. When i use these functions =Small(range,Rows($A$1:A1)) it shows me 7 entries but i want 1 entry of this date. Can anyone help me in this regard, Thanks, Kamran Noor

Good day all, I have customers that need to be picked up every few days, sometimes a large package and sometimes a small package, the type of package is known at the beginning of the year. Is there a possibility to automatically divide this over the year? For instance: Client1: has at the...

Hi I am working on a small numerology project I can extract a a month from the date entered I am a small isuuewith copy the month for example aug-26 to the next row as Sep-26 and further down as Oct-26 How may I automate this process kind regards raj

Hi all So I have a table of data, with the columns being the months of the year. Each row has a range of data, with some or all months having values entered. <tbody> A B C D E F G H I J K L M N O Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sum first 2 Months 1 5 6 8 6...

So the table i have looks a little like: <tbody> Name Rate Tom 5 Tom 5 Tom 10 Rich 4 Rich 8 Rich 8 Harry 7 Harry 8 Harry 9 </tbody> table is actually much more extensive. what im looking for, is to setup another table: <tbody> Name Rate 1 Rate 2 Rate 3 Tom = = = Rich...

I tried to do a 1,000,000 record pull which took quite a while. when the process finished I got this error: expression.error: evaluation resulted in a stack overflow and cannot continue. However, when I do small batches the data comes over fine. Is there a way to get around this error? Much...

I'm trying to compose a formula for if X exists in $A4 and Y does not exist in $A4 then insert Y Please see sample spreadsheet snippet below. The closest I've come is =IF(ISNUMBER(SEARCH(B$2,$A4)),B$3,"") which only checks if X exists then inserts Y. Having trouble with the "does not exist"...