bigger

Good afternoon Dear All, Firtsly i would like to apologize if my question contains any misunderstandings. I have a workbook where there are many sheets with many informations but i want to take a specific value from all those sheets. Imagine that there are lists of products per category in...

Hi All I have a sheet where all the rows have a product image. There are quite a few rows so loads of images - all thumbnail size. However, the user often needs to duplicate the sheet in other tabs, so in theory all the images are copied too and my file size gets bigger and bigger! Is there a...

Hi I want to increase font size or make the code window bigger so i can see better, it is tiny now but ctrl and scroll up or down does not work. any idea how to make the code window bigger. thanks alot

Hello Experts I will like to see if anyone can help me simplify a formula that I just manage to getter bigger and bigger and I know it may be an easier way I have a file that we paid commissions and under the file there a date column so I create a formula to lookup that value and return the...

Good-morning to everyone. Can anyone help me with my problem? I want to compare to columns A and B and color A cells. The parameters are the following. If cell B is a negative number then cell A must be red. If cell B is bigger than cell A then cell A must be green. If cell B is bigger than 0...

Hi i am writing a program which where the user will search data base on the value in the dropdown combo box in the userform. The user can only select the options base on the combo box, there are 3 of them 1st: the type of ship: it will determine which sheet it will open 2nd: Tonnage: which will...

<tbody> Posty: 3 <tbody> Wysłany: Dzisiaj 18:12 Pomysł na formułe Hi, I need your help with this formula: If.error( If(t2>=0;Z2=t2 but if t2 is bigger than y2 show y2 and the second part is iF(Y2+T2<0;-Y2;T2);""). But how to merge it ? Something like that...

hi i have got multiple sizes of stock and i want to separate them in a different groups for example Group 1 (G1) will be less the 10-8-8 640 Group 2 (G2) bigger then G1 and less then 20-10-10 2000 Group 3 (G3) bigger then G2 and less then 40-30-10 12000 i want a formula that will compare...

Hi all, I'm trying to create a formula in which I can pull names from my big data table. One formula and I can drag it down and it fills up with all approved names (based on the criterias). I have names in column A, values in column B and other values in column C. I want to retrieve all names...

Hello everyone, I've been searching for an answer but haven't had any luck. Hope you guys can help. I have this(but bigger): Title 1 Data 1 Title 2 Data 2 I want it to look like this: Title 1 Title 2 Data 1 Data 2

Hi Everyone, I remembered working with If TargetAddress which works with pointers. It really amazing using it to do manipulating since all you do is just use a tab key or arrows. I wondered if this can be applied in a userform. My case: I had a userform with many textboxes of around 60. All...

I have a range of columns (A1,B1,C1,D1). These columns have values from 1 to 20. I have a formula in F1 like this: =if($A1>7,"U",if($B1>7,"X",If($C1>7,"Y",if($D1>7,"Z","")))) This formula puts the value of U,X,Y and Z if any of these cells (A1,B1,C1 or D1) is bigger than 7. but it can't...