large

Hi there Usually when I am running these reports and I have a lot of text in a cell and I have expanded the cell to as wide and large as it can be, usually I'd only have a handful of rows with this issue in a field, my usual quick fix is to insert a row below where the large is cell is, merge...

Hi I have data that I input in to a chart but the output is MBs and id prefer TB due to the large sizes of data. Could anyone help with a formula? Thanks!

I'm trying to find the Largest number (in column A) across a number of worksheets, but I need the names of the worksheets to be dynamic. I can do this with a single worksheet, but using a colon separator within the worksheets seems to cause the formula to have a #REF ! error. I have the names...

I would like to set the row height starting from Row 4 to the bottom of a large table that constantly changes.

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...

How can I get the row number of the result from this formula...

I need to do a LARGE formula, but my data doesn't fall in a range. I have to choose all the cellls. Is there a way to do this using LARGE? Thanks.

I have a table with buttons to add and delete rows. When I add rows they keep adding, despite having a rather large footer and they cover it so you can't read itl

Hi there, I have a spreadsheet where multiple sheets are maintained by different users, however the layout of each is identical. I'd like to create a sheet which pulls all of the lists into one large list, without any blanks. I'd like this large list to always reflect the latest updates to...

I am using the LARGE function and want to skip values if say Column B = "Not Human". Are there any clever ways to handle this?

Hi, I have some sheets with simple colored cells and text. No large graphic files - just standard excel shading. As I am typing this I am waiting on a one page sheet to print that is over 11 MBs what causes he file sizes to get so large and is there any way to shrink them or print faster...

Hi, I am using the formula below simply to add the numbers of one column if certain criterias are met. The file has a large number of formulas like this one and more than that, the data table has a large number of lines and columns. After updating the sql data, the SUMPROD below takes more than...

I have a large (200k rows) data set that I need to filter for different items and split those out to a different tab. Is there VBA method for finding multiple matches in a large data-set and copying out those rows that is more efficient than using the autofilter and copying the filtered data...

I have 2 columns - start date and end date. The start date is populated from elsewhere in my workbook and the end date is entered manually. I have a 3rd col which computed the number of working days between the 2 dates. The calculated cell displays a large number if the end date cell is blank...

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"...

The below macro clears cells that do not match with the D column range. The issue is my required ranges are too large for the macro to run on my computer. Sub REMOVEPIDS()Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False...

I am looking to add something like a FREQUENCY criteria to this =IFERROR(INDEX($B$2:$B$5000,MATCH(SUMPRODUCT(LARGE(($E$2:$E$5000=1)*($M$2:$M$5000),ROWS($A$1:A1))),IF(($E$2:$E$5000=1),$M$2:$M$5000),0)),"") I have my index categories in Col B, and my LARGE in Col M, Col E is just a Month - if...

Okay it is what you think :) 1. I made a GIGANTIC code which traverses the entire workbook. And right when I was almost done, I got "procedure too large." This appears to be because the compized size of teh sub is > 64 kb. 2. I do not want to break into two subs, because the setup is so...