smaller

I have a userform that is to large on screens that are 1920*1080 or below, how can I check users resolution and if it is smaller or 1920*1080 I want to display the small userform? If it is 1920*1080 or bigger I want to display the normal userform?

Hi, it seems to be a small thing but can’t wrap my mind to it. I have 2 columns. One has a formula resulting in a number. The other one has plain numbers. I need to use 3 colors for Greater than (green) Smaller than (red) Equal to (yellow) I know to use =value(b1)=value(a1) But where...

I have a line graph in Excel on Mac. The size and location of the labels on the axis change based on the width of the characters included. Wider labels get slightly smaller and move up higher. Smaller labels remain larger and stay on the bottom. These are all the same number of characters...

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,</SPAN> I want to count from smaller to larger valve of each row and put them in one cell separated by vertical bar. Is it possible?</SPAN></SPAN> As per example below</SPAN></SPAN> Book1ABCDEFGHIJKLMNOPQRS12345n1n2n3n4n5n6n7n8n9n10n11n12n13n14Count Smaller to...

=INDEX(F$44:F$79,SMALL(IF($S$44:$S$79=$S$42,ROW($S$44:$S$79)-ROW($S$44)+1),ROWS($A$1:A1))) It is possible change above formula in section =$S$42 to options biger and smaller at the same time (for sample >$S$42-3 and <$S$42+1) Both below are obviously not working...

Hello! Trying to figure out how to take a table of data and split into individual smaller tables. The source data table columns and rows are variable, from a few columns/rows to quite a lot, so maybe a message box asking user to select Range? or something like: Dim c1 As Range Dim c2 As...

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

Hello, I have a master list of data and a bunch of smaller lists. The data in the master should contain all of the data in the smaller lists. I need a formula to return a yes or no if a row in the master is represented in the smaller list. Think about it this way: I'm trying to check if a row...

Hello, I have a master list of data and a bunch of smaller lists. The data in the master should contain all of the data in the smaller lists. I need a formula to return a yes or no if a row in the master is represented in the smaller list. Think about it this way: I'm trying to check if a row...

Hello Everyone, I currently get a list of addresses from a lead generation company daily. I want to be able to take that list and segment it into smaller lists by zip codes that are in each of my companies territories. This way I can make Mail Merge documents from the smaller lists so they...

Hello everyone. My computer is Dell and I'm working with Office 10. I'd like to know how I can use a formula to subtract a larger number from a smaller one without creating a negative. For example: <tbody> <tbody> <tbody> 16 16 16 16 29 31 65 67 -13 -15 -49 -51 </tbody>...

Hi All, Is it possible to have a formula compare the values in A1 and A2 and place the smaller value of the two in A3 with a Maximum value of 70? Thank you for your help

Hi there, I have a problem which has been bugging me for ages... I have a userform with a multiline text box (limited to 400 chars). I also have 4 seperate text boxes (not visible to the user on the form) What I'm trying to do is strip the large multiline-textbox into the 4 smaller text...

I made a macro that is too large to even post on here and will not run in excel because it is too large. Can anyone help me to make this smaller? I'm completely clueless. Took me almost a month to create this just to find out that it is too long. :( I should have been smarter...

How would I condese this into a small amount of lines and add additional rows/columns if I needed to Sub Converter() ' ' Converter Macro ' ' Keyboard Shortcut: Ctrl+Shift+H ' Sheets("Unconverted").Select Range("B2:AP2").Select Selection.Copy Sheets("Converted").Select...

Could someone please let me know if it is possible to shrink this countif statement? It becomes too much to handle since I have to copy it for multiple different rows. The A1 stuff is to know if the sheet is "active" (if there is a different way to do this I am all ears) it would need to stay...