limit

  1. B

    Time limit to enter data in a cell

    Hi Everyone, Somewhere I read where one can put a limit on the time it takes to enter data in a cell and now I am not finding it. The idea is to be able to populate a cell with a hand held scanner and not be able to edit that string manually because of a time constraint. I have experimented...
  2. N

    credit card conundrum

    Hello everyone, I’d really appreciate your help with this problem please… We are managing our business spending across 4 credit cards. Each credit card has a different limit. The total limit is £54,000 Every time one of the cards hits it’s credit limit, we move spending to the next card in...
  3. R

    "Min" Function in Excel

    In the below excel table I have two steps and am stuck on the second. My first, StepA, Apply attachment point,Total Value – Attachment Point. If result is less than zero, than the exposure to the policy = 0. (= IF(TotalVal – AttchPt < 0, 0, TotalVal – AttchPt)) For Step B - Apply Policy Limit...
  4. H

    date file was last modified

    OK ... I searched before posting ... and almost had it. I simply want to list the date a file was last modified in a spreadsheet. There are several files listed. Here is the thread I found ...
  5. S

    Conditional Formatting

    I have to show RAG status for the following in a 200 row document. How do I set up my formual Green - no users exceed 95% of 1GB limit Amber - Site does not have users that exceed 1GB, but does have users over 95% of 1GB Red - Site does have users who presently exceed the 1GB...
  6. bobgrand

    Conditional Formatting for 20,000 rows

    Hello all and Happy New Year, I have 20k rows of data where I need to highlight cells E thru I if a condition in column R = "LOWER". I tried the conditional format but it looks like it has a limit to how many rows are used. Any help would be greatly appreciated.
  7. B

    How many Custom Formats can Excel hold before crashing

    Is there a limit as to how many custom formats Excel can contain? I read somewhere it might be 64,000 (based upon a workbook with 100 sheets or so). Is there a limit to how many custom formats (i.e. fonts, typeface fill, alignment, numeric, borders, conditional formatting) that Excel can hold...
  8. M

    Limit range of timeline - Excel

    Hi, Is there a way to limit the range of a timeline created in Excel? The issue in my file is that the timeline date starts at 01 Jan 2017 and ends on 31 Dec 2018, but my data cover only from Nov 2017 to march 2018. Thanks. File: https://ufile.io/sov2w
  9. J

    Bug - Registration issue

    Are you a human?:Enter the number of days in the month of January I was met with this question upon registering, yet it would not allow me to enter "=EOMONTH(1/1,0)" as the character limit is 3. Perhaps the character limit should be extended when = is the first character? :) Cheers, Jon
  10. P

    Google sheet forumla translate to Excel

    Hi All, I have the following formula that i used in google sheets but now putting my data on excel but need the following formula to work in excel or something that does the same Could anyone help at all please? <style type="text/css"><!--td {border: 1px solid #ccc;}br...
  11. J

    Need a formula that can calculate employers cost on employees payroll with the following.

    Employee wages = x Social security tax rate = 6.2% Social security limit = $128,700(no tax payed after) FUTA tax rate = .6% FUTA limit = $7,000 Medicare tax rate = 1.45% No limit
  12. M

    Open email limit

    Hi Guys I have created a macro, which create emails and attach files. There are about 115 email that i create. I havent activated the code to send those email automatically as i want to check them before i send them. But for some reason , it only opens up about 90 emails out of 115. Does...
  13. E

    Tiered Cost

    Hello, Looking for a formula. If For instance in a given period, total Sales went from 9 to 11. I need Sale #10 to be at 0.5 and sale #11 to be at 0.4. Last month and this month Sales are in M2 and N2 respectively If for instance, if sales went from 35-42. I need 5 sales at 0.2 and 2 sales at...
  14. HomeTek

    Nesting Limit Hit Using IF and AND functions

    Hi all, Using Excel 2007 I have Googled and Googled and tried to use various examples to help me with this but to no avail. I know nesting isn't ideal, but I need to possibly nest around 10 statements. However I have hit the limit of 7 and can no longer add any more conditions. Below is an...
  15. S

    Increase Nested-If limit more that 07

    I need solution for increasing Nested-If limit more that 07 Please help
  16. reneev

    Conditional Formatting Using Formulas

    I need do to a conditional format using a formula. I need it to highlight the cell A2: if A2 contains the words "Limit PT" and A1 is =<56. I can do the second part, but I've never had to do a "contains" formula so I'm not sure how to do that.
  17. bs0d

    Custom Ribbon Combobox - Limit Display

    Is there a way to limit the display of combobox items in the Ribbon? Or if I have 1,000 items- will it will show a list the height of my screen with a scrollbar?
  18. C

    Conditional Formatting OR function: Text Value already contains Quotes

    I'm using Conditional Formatting to colour cells if they meet specific text criteria. I want to compare a value if it's either this or that, then if so, colour the row green. Easy to do, I would think. I can get the first part but not the rest because the value is already enclosed in...
  19. O

    VLOOKUP with ranges

    Hey, guys, I'm aware its possible to use vlookup to search in a range. However, let's say you only have the maximum limit. For the purpose of example a have column A with amount and column B with percentage. Column A figures represent salaries: <tbody> A B 632 0% 645 3% 683 5,7% 736...
  20. T

    Highlighting cells in a pivot table based on exceeding a limit value, but limits are different for each category.

    On a pivot table I have categories of inventory and each one has a quantity on the sum. I want to highlight the quantity if it exceeds a limit but the limits are different. So if the sum of catalog codes for the category 'core balloon devices' exceeds 10, i want to be highlighted. But if the...

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