limit

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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.

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?

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

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

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