small

  1. muhammad susanto

    Automatic Sort Number From Small

    hi all.. how to make sort from small number : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px...
  2. F

    Long Code, Sum I

    I need help, I have a Quotation that I have made for work. It has drop downs Lists to save time and speed up the completion of the quotation. Problem is I have added a drop down List under subtotal is for offers like 20% off ect. the one I'm having trouble with is the free packing material...
  3. I

    Assign a cell a specific value

    Hi, I'm not sure if i have the correct title on this thread, here is what i am trying to achieve. I have 4 shipping templates. 1. Flat Rate Envelopes 2. Small Box 3. Medium Box 4. Large Box I also have an excel sheet that has products, each product has one of those shipping methods above...
  4. K

    Column match on same row

    I have a table with Sku and Item Name. There are multiple lines with the same Sku. I want to take this information and create a table showing one line for the sku name and place an "X" with the Item Name that make up the Sku. Beginning data table <colgroup><col><col></colgroup><tbody> SKU...
  5. S

    Small triangle in random cells at top left hand corner of cells

    A friend of mine is doing simple sums of cells, but in certain cells in that range a small triangle appears in the top left hand corner of that cell. Whatever you input in those cells do not add up in the results cell. Their is some form of strange formatting happening here, Any ideas ?
  6. A

    In-person training/consulting available for small business?

    I'm new to this site and couldn't find anything regarding any type of personal/face to face consulting or training services. Does anyone know if this is something that's offered and if so what/who is best person to contact? I work for a small business (10-15 people) in Eastern NC and we could...
  7. M

    Index Match On Multiple Columns

    Hi and good evening,how would I perform a lookup on 1 unique "date time value" in columns D and F and return their matches from columns C or E all sorted from oldest to newest (like finished Data Set below).Times and Dates in columns D and F are formatted as "ddd-dd-mmm-yy hh:mm".Also I would...
  8. E

    INDEX when a cell has multiple text and return a value

    Hi Everyone, I have this formula that I got working for what I want and now I am trying to add another level of complexity to it. Below is the formula I use to search for a Person's name and if that person's name matches then it will show the task assigned to that person...
  9. A

    Cell border

    After applying a new Interior.Color, how do you keep (or restore) the small dotted borders around each cell ?
  10. K

    Distinct Count Based on Multiple Criteria

    Hello, I am building a tab [results]; on this tab, I have a column [column A] which lists a unique value (description). In [column B]; I need to create a formula. This formula needs to look into the [raw data] tab, and count the number of distinct IDs which share the same (description) and...
  11. B

    Matching Values in Tables

    I have a MAIN empty table (for example 6 rows and 6 columns, see table below) and a SMALL table which is a subset of the main one (say 2 rows and 3 columns) and contains data. What formula I can use in the MAIN table so that each cell gets populated with the corresponding values from the SMALL...
  12. P

    Using Clipboard_SetData function to copy small table

    Hello, Within Access 2010. I am familiar with using the the Windows API, and then creating the function, Clipboard_SetData, which will copy some data to the clipboard, when called. Testing this, the function works fine for a small string of data. However, in my database, I would like to use...
  13. M

    VBA window sometimes opens very small

    When I open my Macro-Enabled workbook and then click Developer -> Visual Basic, the VBA window sometimes opens extremely small. It doesn't always do it, but I'd say around every 5th or 6th time I open the VBA window (when Excel has just been launched) it will do this. Anyone ever have this...
  14. M

    Access Query won't run, getting error.

    Hello and thank you in advance if you can help, I am using Access 2019 on a PC. I have a database that under properties is said to have a size of 2.87 MB. All my files are linked, four data files as text imports (two 1 million + records, and the other two small, a few thousand), 8 lookup...
  15. kelly mort

    Validation of texts from two different textboxes

    Hello I am looking for a script that will compare the values in two textboxes to see if the both contain same words. One box has "Small Yellow Car" Second box "Car Yellow Small" "Small Car Yellow" Etc Rules : 1. The order does not matter 2. The length of characters in both cases must...
  16. R

    Return multiple values from a column based on multiple lookup values

    Hi, I have a list of look up values Client A Client B Client C Client D I want to create a formula which would look up Client A, Client B, Client C, ... values in a range and return any corresponding values to these lookup values. The formula works if I try to look up only A value in a range...
  17. K

    Index Match (Small?) with multiple criteria

    Hello. I trying to get results from a report I run, and I a, attempting to match a couple criteria. The report will have more than one row that will match the first criteria. Then, from those, one will match the second. Then I can get the value I'm looking for. Im using Index/Match for some...
  18. E

    Table with non-blank and blank data to a table with non-blank data only

    Hi excel gurus, I've been browsing through the forum and have not been able to execute a formula to make this work!! I want to be able to transfer this table with only the filled in columns to a new table (RPM, Engine, SSG, Hatch, Location will have data inputted by the user, the Time column...
  19. R

    Urgent need for help: Extracting data to a new spreadsheet based on one criteria but multiple matches

    I have a daily sales spreadsheet that is added to daily. It is everything that is sold from 1/1 to 12/31 each year. It lists salespeople and items sold etc. I need to create a spreadsheet for each salesperson monthly to track their commissions for the month. I have pulled that spreadsheet in...
  20. M

    Sum by blocks

    Hello,</SPAN></SPAN> I need to sum column "C" depending on as per column "D" blocks (blocks consist with 0's or largest to lowest number ended with 1)</SPAN></SPAN> Here is a small example... </SPAN></SPAN>...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top