smaller

  1. W

    How to show different userform based on users screen resolution?

    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?
  2. V

    Conditional formatting mixes equal up

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

    Chart Axis Issue on Excel in Mac

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

    VBA to 'breakdown' an integer into smaller integers

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

    Count all values of each row from smaller to larger

    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> <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  6. Jan Kalop

    Index...small....row

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

    Create Smaller Tables From Larger Source Data Table - VBA

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

    vba conditional format

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

    Comparing Rows in Excel Between 2 Sheets.

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

    Comparing 1 Row to a Group of Rows

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

    Sorting A large list into smaller lists on different sheets

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

    A quick question about subtraction

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

    Min + Max in same formula

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

    Userform - strip text from textbox to seperate textboxes...

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

    Need to make macro smaller

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

    Make Macro smaller and condensed

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

    Super long countif divided by super long countif

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top