large

I would like to insure that when ever a workbook is opened it would automatically: Sort all the entire workbook small to large in Colum a, retaining the headers? Thanks -Eds

Hi, I need help working out if a product is Standard, Medium or Large size based on the length, width and height dimension with the following restrictions: <thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">#C7E0F9[/URL] "] Standard...

Hi, I had a formula which worked out the sumproduct large for a range of cells which excluded the highest figure. =SUMPRODUCT(LARGE('Stableford scores Summer 2018'!B5:AG5,{2,3,4,5,6})) The problem I have is that I don't want to include the value in every other column i.e C5,E5,G5 etc. Does...

I currently have an employee database which is based on Excel. Sometimes, we need to print off employee information for only a handful of employees. When this occurs, normally the admin just copies and pastes each employee record into a new sheet which takes a while as it means trawling through...

I normally use data tables to manipulate large data sets in excel but once you start using reasonably complexish formulae it makes the file huge and slows it right down as there are so many calculations to do. Is there a way to store the data in Access and then link from excel and manipulate...

Hi, I'm creating a LARGE IF array funtion as follows: =LARGE(IF(Master!$B:$B=A1,Master!$F:$F),1) The A1 is a drop down list that is selecting a Category name and then selecting the nth largest number in Col F from 1 - 10. I also want to include an option to look at all rows in Col F so that...

Hi, I've got two columns where I need to make sure that the order respects: 1 - The large value from column A5 to A10 (Total differential of runs scored) 2 - The large value from column T5 to T10 (Total points awarded for a win) The issue that I see with the current Large(Array,k) is when...

I have a large comma delimited file that i want to setup into a multi-worksheet spreadsheet file. When I was handed the project......I set it up very quickly into a pivot table and sent it back to my boss. All the users would have to do is choose their location(s) from a pivot table filter...

I need to edit just 2 of them, and the file is large so its too much time until it loads. Is is possible to open just the one I want to edit? Have a nice day!

Hello guys, it's 4am where i am and i have been working on this project for 8 hours. I cannot find the simple solution on google. I basically have an array of cells that are not in a column or row (cannot organize them either as the file is quite large) that contain numbers and i need to know...

Working on IF logic . Does if take in range like (200-500) then x I tried writing this formula =IF(J2=(50-200), "SMB", IF(J2=(200-500),"MID MARKET", IF(J2=(5000-10000),"SME", "Large Enterprise"))) But it did not give me the required answer which was supposed to be "SMB" Any pointers?

Calculate a cell with set of rulesI want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Very Large"

I want a formula to calculate K8 with these set of rules: If C8 is 0 to 25 than K8 = "Very small" If C8 is 26 to 35 than K8 = "Small" If C8 is 36 to 45 than K8 = "Large" If C8 is greater than 45 than K8 = "Very Large"

Hi, trying LARGE IF for the first time (array formula) but I cant get it to work.. How can I correct the formula or is there a better formula I should be using {=LARGE(IF((OR('30 DAYS'!A:A="1",'30 DAYS'!A:A="IL")),IF('30 DAYS'!D:D=NJIL!A:A))),1)}

I have a large spreadsheet with number variances to budget. I want to be able to click on a large variance and it take me to a different worksheet and enter a specific value into a specific cell. Is there a way to do this? Example if I double click on cell A4 in sheet1 I want it to take me to...

I have a range of Keywords (named range Devices) its a somewhat large list 586 lines (it will grow over time). I have on another worksheet a large amount of data will grow to about 100,000+ lines by end of year. I want to search to see if cell A2 in this worksheet contains one of the keywords...

I have data from shows for different ponies. I need to select the best 15 events by pony and division between specific dates and sum those for the total qualification points for different events. Sample Data <tbody> Show Date Pony Division Points Show 1 1/1/2017 Pony 1 Small 150 Show 1...

I am very new to PowerBi and have a question about Top 10 rankings by count of model number. I have some large tables that have multiple sites on them like: Boston, New York and Chicago. At each site they will have a list of top 10 models used. Since all of this is in one large table "query"...

I have a spreadsheet similar to this. I am filtering the column of numbers for the 3 highest, which works well. What I am wondering is how do I get the labels to follow the data? Say I have two spreadsheets. I am using LARGE to sort through one sheet and put results on a different one...