Search results

Thanks Luke, that would definetly work for myself, but for presenting its kind of a no no.. I will still try it out to see If It works better on a bigger scale that what I have.. thanks again!

Hi, So I have several income and expenses accounts that I get the acumulated balance at the end of every month, and I have made a matrix formula (complicated and very heavy and time consuming to calculate due to the amount of data that needs to be calculated) to be able to show the real income...

The force is strong with you Luke!!

Thanks Luke, great example, using this same example I would need excel to return "Getting bigger" because my ranges are max values or "up to" values. That is my problem right now, everything I try, gets me the below range

Hi all, I need excel to know in what range a value falls and get bac a fee thats asing to that range. Normaly I will use Vlookup but the ranges are many ( for example, up to 95k the next one is up to 100k but the next is up to 101.5k). I already have my ranges in one column and each fee next...

Hi I have a file that i need to be saved as a PDF but on the desktop every time and if I could make the file name the same as the content of a cell it will be great. Bellow the code, this sabes as pdf but in the desktop of my pc, the file will be in diferents computers when the button with the...

Hi I'm Carlos from Panama (central america). I thought I was good in excel untill I got hired by a bank for the business intelligenge dept, and then I found this website. I want to becoome as good as posible in excel, and apreciate all the help.

Hi Guys, Just had this same problem, selecting a month filter in 3 diferent pivots. I used a combo box method to select the month, then the link cell wil give me a number, next to the number I used a vlookup to get the correct month back. Then used this macro to make the pivots filters...