length

I am trying to write a formula that rounds up (or down) to the nearest whole number. Here are my parameters. This is for optimizing material lengths in manufacturing..... Cell P40 = number of stock lengths required Cell D22 = Quantity of Pcs Cell J6 = Length of Each Pc. Cell I40 = Length of...

I have an excel template (Productivity Tracker), where we have to put specific request number based on various task. For e.g. for task MDC Account Creation, request number should start with "A" follow by seven digits(numbers) ex A9827366, total length 8. So, for each different unique task I have...

I have in column D strings like A1B1C1D1E1 or A5B1C3D1E4 etc There can be blanks too. There length will always be even if not blank. Which means we can have from 2 characters up to 10 characters. So from the above given example if cell D2 is having A5B1C3D1E4, then I am splitting it and...

Hello, I have a measuring device on 4 x machines which measures run time in minutes and metres of material run through the machines. The measuring device outputs the data into Excel but the format isn't great it displays as: Date, Time, Machine 1, Runtime Date, Time, Machine 1, Length Date...

hello all, I need help with the funtion I am able to do len first and then if function but i cannot get them to work together. I need a function that can take the Length of the numbers in cell B17 and if greater than or equal to 8, display a value of "Cusip" If the length is less than or...

Hi everyone, Is it possible to count the number of dashes in a string that do not have space on both or just one side? The string length will be inconsistent so cannot use number of words. e.g. "This-document" would be counted, whereas "This - Document" would not. Thanks!

Is it possible to use TRIM where the field lengths are not consistent? I need to remove the first character of a field but the length varies between 4 and 8 characters, so wondered what the options were please.

I need a macro code which I can attach to a command button which will expand specific rows based on cell values. My sheet has a series of questions. or each question, there are 4 possible answers in a drop down menu in column A. If the answer has more than 4 characters in length, I need the...

Hi, I've searched the archives and though I've found similar issues I haven't been able to figure this one out. I have a list of IDs in column A on worksheet 1. One worksheet 2 I have a vlookup returning modality and length, but in cases where there is more than one modality or length I can't...

Hello,</SPAN></SPAN> Note: Colours in column D are filled just to explain the example purpose </SPAN></SPAN> In the column D I got some sequence of numbers and I got a formula, which counts the length of 0's in the G6:G19 now I need a formula, which can count delay of the 0's length in...

Can anyone offer any insight as to why a cell with 2:41:00 PM in it, doesn't match another cell with 2:41:00 PM in it? I've checked these items: Formatting is exactly the same (hh:mm) Length is exactly the same To further confuse matters, other instances where the same check is performed...

<tbody> TABLE 1 Widget --Length of Widget-- --SF of Widget-- $$COST$$ </tbody> <tbody> TABLE 2 --Length of Widget-- $$COST$$ 0-5 Feet $10 6-10 Feet $15 </tbody> I need to create a formula that will calculate the cost in TABLE 1 assuming a minimum for the --SF of Widget--...

I feel like I am pretty good at VBA, but, I have always struggled with wrapping my head around recursion. I banged my head against the wall for hours this morning trying to figure this out. I got the code to work, but I am sure there must be a better way to do it. I would like to get better...

Hello! How do I expand a selection of multiple columns so that they expand by a specific length that I drag the border at? This is ancient annoyance and I don't know how to fix it! Thanks!

Excel 2010 32 bitABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF1Main LengthMax Length250382.0345678Main LengthSection LengthsTopBottomFinal...

Hi all, New Member here. I hope you guys can help me. Ive asked this on another forum and didnt get a useable answer. https://www.excelforum.com/excel-programming-vba-macros/1254244-distributing-numbers-into-sets-that-maximize-their-total.html#post5016154 Im hoping someone here can help. I...

Hi there, Hoping someone might be able to help me with a Formula to calculate the funding availale for a Nurses Scholarship Fund Entitlement based on length of membership. I have a cell showing length of membership in years (say A1) and another cellshowing length of membership in days (say...

I'm really sorry: error, please delete.

Say I have the text, "There was no fire alarm. There were no sprinklers or fire escapes. And when a band member tried to put out a fire that had been started by pyrotechnics, the extinguisher didn't work." in cell A1 and need to calculate the average sentence length for that cell. I tried...

Hi, Im looking for a code which would allow me to split string/ text in one column ( which contains combined 5 length strings max 6 of them) into other access columns, each column should contain one 5 sings string. I looked up all the build in formulas but none of them fully responds to this...