large

Hi I have named the columns as below... And using LARGE function to get the top 5 values arrangement And using INDEX & MATCH to match each score with its name The problem here that I found duplicated names for the same score, but what I need as follows... Name D Score 7 which is the...

I have a large excel sheet with a list of email address in column A. This is the only column in the sheet. Column A has about 20,000 emails, and I would like to split this into multiple adjacent columns with exactly 400 emails per column. Is there an easy way to do this?:confused:

"The picture is too large and will be truncated "

Hi, I'm using a LARGE formula to show Top3 and Bottom3 on a set of data that does not fall in a range (hence, individual sells are referenced)...

Hello Excel Guru's, Just wanted to ask for your opinion if below formula is great for large data look ups. =IFERROR( IFERROR( IF(G2=VLOOKUP(G2,B:B,1,1), VLOOKUP(G2,B:C,2,1), VLOOKUP(G2,B:C,2,0)), VLOOKUP(G2,B:C,2,0)), "-") Thanks.

D1=5 D2=4 D3=9 D4=Sum(d1:d3) But I want d4 instead of showing "18", I want D4 to show "8" and C4 to show the "1"... But I want this formula for numbers as large as 1,000,000.00 So I have 9 individual cells from A:I across. And when ever the number is large enough I want it to "carry over" the...

I have a situation where I would like to compare variables 27 different times, and output the results to a MsgBox. Even a simple true/False would work. Test 1 would have variables A & B Test 2 would have variables A2 & B2 Test 3 would have variables A3 & B3 .... Test 27 would have variables A27...

I have a large sheet that contains a lot of duplicate values that need to be looked at then possibly removed. When I use the conditional format tool to highlight duplicates I can manually go through and determine if they should be kept or deleted. The problem is because the sheet is so large...

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 Everyone, I am looking for a VBA solution for the problem described below but I couldn't figure it out. Any help would be great! The "Large Number" column and the "Component" column are the input and they are all integers. I was wondering if there is a VBA solution to "break down" the...

Hello, I have big problem. I want to make a 1,2,3 biggest numbers but there is two simillar so exel write two same words, how should I write the formula? =INDEX(A4:A16;MATCH(LARGE(H6:H16;{1;2;3}); H4:H16; 0)) How should I correct this formula? If it need, i can add the photo. P.S. sorry for...

Hello folks, I am trying to use the below formula but it's too large, apparently. Can anyone tell me what I need to do to shorten it? Thank you so much...

I have a large file that is about 2,000 kb in size. I am looking to add more rows in it with formulas and when I do the file slows up. The file does contain a few Macro's. I have tried saving the file as "Binary" and I even change the Calculation Options to "Manual". Even with a smaller file...

Hello, Due to a large size file, i'm attempting to remove OFFSET from the below formula (seems i cant copy the formula in this forum?) My attempts have been unsuccessful so far. Any help would be greatly appreciated :) PS: Do you know if I store today in an isolated cell and point my formula...

I've spent a lot of time trying to optimize my workbook (which streams in a high-volume of real-time stock quotes) for speed, e.g.: (i) getting rid of resource-hogging dynamic functions, (ii) and particularly hardcoding values wherever possible (with macros that calculate formulas and then paste...

I am doing an index match with a large formula, however I have duplicates values in AT1-BE1 =INDEX($AT$1:$BE$1,MATCH(LARGE($AT2:$BE2,COLUMNS($BF2:BF2)),$AT2:$BE2,0)) Is there a way to show the values that have duplicates? Thanks!

Hi All, I need your help to find out only formula cell with highlight with color quickly. i have a large file with lot of small formula. Thanks

Hi, Need help with a formula that will find the top 3 in a table and place the item in cell before. In bottom table, D will have formula that will pick up 420, and C2 will pick up SQuash, then D3 will pick up 325 and C2 will pick up Okra. and so on. I found how to use =large to pick up in order...

Hi, I would like to generate a list with the top 3 people with the highest number of incidents in one year (including their name and count). I have a list of names with their incident counts, but I have trouble listing the top 3 because there are duplicates in the incident counts. I can't do...

I am trying to copy a large amount of information from one spread sheet to another but i need to close the first spreadsheet down before i paste the information When i do this i get that annoying message box pop up and have to press yes everytime. Is there anyway i can do it using my vba. I...