100k

I'm guessing this can be solved with a sumproduct but I really don't know for sure. <tbody> 0-5KM 50% $5 5-10KM 15% $10 10-15KM 15% $15 15-20KM 10% $20 20-30KM 5% $25 30-40KM 5% $25 </tbody> Here's a table which shows how much we charge (col C) for various distances. Col B shows...

Hello- Can you please help with a following IF formula:- If it is below 100K ten I want 0XX between 100k and 999K, then 1XX Above 999K then 2XX Thank you!

Hi all I need to copy a list of 100k entries like the one below. =-ad-vehicles. Problem is when i paste, i get #NAME ? in the cell. I know it's doing this because excel thinks this is a formula function but how do i work around this considering that i have to deal with 100K entries?

Hi Guys, First of all this is great forum, before opening this thread i already searched around and found some formulas that has helped me tremendously. I will be opening few more threads one after another to make things easy on my tiny brain. as of now I want to do the following: I have List...

I have an Access database with 34,061,507 rows of data. From that I need prob 30k of these rows, Excel home 365 does not allow PowerPivot. The data is a unique location ID I need to pull back 500 out of 100k of these and also the date I need about 60 days out of 365 (for most stations). Any...

I have a 100k lines workbook, that 36 columns are used. It has 25mb, every line has formulas, I've also use color rules on columns. It takes long to open and it seems pretty heavy to edit, modify. Is there a way to make it much lighter? Or Excel can't be light with so many lines?

I'm having a slight issue. I've created a colossal sized data table that pulls through from multiple files via sumproduct. As is it well over 100k lines long with sumproducts on multiple columns * 100k rows, it takes a while to process. That said, when I go to copy 2 columns of data when I...

My data source has two header rows, for which only one is ever populated. I want to take whichever is non-blank as my header. My instant reaction was to transpose in Power Query, add a custom column that picks whichever is non-blank, and then retranspose. However, the transpose step took ages...