large

Hi, I am using the Large function to calculate the rank and Index and Match to return the user name of that rank. Some of the ranks have similar values and then returns only the first name of that rank value. I would like it to return the correct user name for each rank value.

I am trying to find where the top 3 values in a range are stored. That part is done, however, if one or more of the top 3 have the same value, I only get the same cell locations and not the top 3. Here is how my data looks like: <tbody> A B C D E F G H I J <tbody> 0.22 </tbody> <tbody>...

Hi, I´m fighting against an elusive formula to assign scores, I have tried to use arrays and combinations of functions seen in old posts... with no positive results. I have a long list of rows of concepts, each of them related to several values that appear in columns, so they must be compared...

I sometimes take screenshots on my 4K monitor and upload them to Imgur so I can embed them. Any ideas why they come out so large? It's not a problem on mrexcel.com. Even when I view them on Imgur.com, they look big there also. Example: They seem to be getting scaled up by a factor of 2.5.

Hello I have tried with Large IF OR, but it creates a boolean and Large dont care about that. I also tried with Sumproduct, however that only seems to function with 2 criterias that isnt OR but rather AND. To simplify my question i will ask with the alphabet. I have clipped my data in below...

Hello In Column Meter Type I have the following formula =IF(AA2="LARGE",AND(AC2={"BASIC","MRIM"}),"Meter Requires Upgrade") What I am trying to say is that if Column Classification contains the value "LARGE" AND column Meter Installation Code Contains the value "BASIC" OR "MRIM" then mark...

I have the below Formula using LARGE and right now it returns the largest value in the column, but the Column is a UID field and I am just using it to determine unique value, I want to somehow wrap this formula with and INDEX / MATCH array and first use LARGE to find the largest UID, then using...

I need to add the text "ABC" to the end of some worksheet tabs that already have names. It's a couple hundred sheets in the middle of a large spreadsheet, so I cant use code that selects the entire workbook. Thanks

Hi, I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries. The order of the formulas is as follows: web query --> cells referencing the table created by...

HI, How large are ODC files? I have one that is 3mb, even when I reduce it to a few lines. Itis slow and lumbering. Is this normal fo ODBC files? Thanks

Hello, Currently I have the following formula which works great: {=LARGE(IF($Z$1:$Z$10000="EQUITY",$AA$1:$AA$10000),J23)} If I then wanted to include other candidates for large, with different text values than "EQUITY", all in column Z, how would I expand the above to include these?. Been...

I built a fairly large and complicated financial model for valuation purpose, I’m now concerned with calculation speed. A couple of questions: Does table slows down calculation a lot? My data is kept in tables so that other formula referring to the data will auto update when adding deleting...

HI all I have several large numbers 019332961003232531020025441319041221179549530 19332961003232531020021401319041221179549570 1933296100323253102002236131904122117954954 0193329610032325310200235813190411211795387001 933296100323253102002280131904112117953858...

I have been using Excel 2010 to build some large workbook for almost a decade. The workbooks are getting so large that they become very slow. I am wondering if Excel 2019 performs faster than Excel 2010, so that I can try upgrading Office to get faster calculation speeds. Any opinions? Thanks.

Is there a way to utilize the LARGE formula, but have it pick the highest consecutive periods? I am looking at a very wide set of data, 20 years by quarter, and need to find the peak volume for any four-month (consecutive) span. The LARGE function is only finding the biggest four months...

Hello I tried many combinations of formulas but every time first and second highest value is the same im getting first key for both. DATA <tbody> # A B C 1 1 USER1 8 2 2 USER1 8 3 3 USER1 4 4 4 USER2 5 </tbody> Display <tbody> # A B 1 [find key [DATA A:A] of first highest value...

I'm trying to combine a Sum IF and large formula. My Sum if formula is =SUM.iF($P$7:$P$300;$A$7:$A$300;AA39;$R$7:$R$300;"Forc") And I want to sum the largest of $P$7:$P$300, i would like, if possible, how many of the largest numbers to sum to be based on AH39.

Hello, I wrote a macro to pull a large dataset from excel and put it in multiple powerpoint slides....everything works great but the text "pDesc" is often too large for the shape I created in the piece of code below. I have to keep the shape the same size so I have to think of a way to auto-fit...

I have see the answer to this here, but cannot find it now that I need it. I need to take a very large spreadsheet and make separate tabs in the same spreadsheet based, in this case, on a combination the county and state columns. (each County/State will have a separate tab in the...

Is it natural for Excel not to update automatically values based on formulas in a sheet with several formulas in a large file? I have to save the file in order to refresh the formulas' values. Or there is a problem with my Excel or PC?