# Infinite Numbers Of Data

Feb 26, 2008

I have a problem with creating a spreadsheet.

I need a dialogue box, which asks the user the following:

* 1) Number of Plants
* 2) Number of Feeds
* 3) Total Daily Hazard (4*1)
* 4) Amount of Potentially Hazardous Food Daily
* 5) Excretion Rate Daily (% of Remaining)

I then need a table to show:

Along the top - The Number of Feeds (2)
Down the Side - The Number of Plants (1)

This is to show the amount of Potentially Hazardous material in each plant per day – and also the amount of Potentially hazardous material in ALL the plants per day on the bottom line.

Simple? – Well, my problem is that I need to create a loop which will work with the data potentially being infinite – The Number of Plants (1), The Number of Feeds (2), could be anything from 1 to Infinity.

ADVERTISEMENT

## Infinite Loop

Jan 22, 2010

i'm trying to loop through a bunch of worksheets and copy certain cells and paste it in a master sheet.

Please take a look at my code below because it keeps copying the same thing over and over and is stuck in an infinite loop.

## How To Concatenate Infinite Cell

Dec 23, 2013

How to concatenate the infinite cell in one cell. See the attachment .

I need the data in column A ...

Attached File : abcd.xlsxâ€Ž

## Renaming Files In Infinite Number Of Sub Folders?

Feb 25, 2014

I have written a procedure that renames excel files within a folder based on certain words being in the title. It works for the files in the first lot of subfolders but I am trying to work out how to get it to rename all files in all subfolders regardless of the level.

I've seen similar things done using recursive subs but I have been trying to convert some of the sample codes I've found online to fit my situation and am not having much luck.

how to manipulate my code into something like a recursive procedure or anything else that will do what I want.

Here is my code.

[Code] .....

## Setting Value In For Each Statement Stars Infinite Loop

Sep 17, 2009

Setting value in For Each statement stars infinite loop. I am trying to get the following script to work

## Excel 2010 :: Search Gets Into Infinite Loop?

Feb 5, 2013

I have various spreadsheets that get into infinite loops sometimes when I search for things. Hitting break breaks it, and the search window (find all) shows the same exact entry hundreds of times.

This is Excel 2010.

## Sine Of An Angle X By Summing An Infinite Series In VBA

Jul 18, 2006

i was set some work related to maths to be carried out in VBA. the problem for me is im finding it very hard to understand either and so i cannot seem to work out how to complete the assignment given.

i can attach the assignment to save space and time reading on here however if you would like me to post up the assignement i can do that too....

## Extracting Numbers From Text And Turning The Numbers Into Rows Of Data

Feb 23, 2010

The format of the text in which I need to extract numbers is as follows:

23411268 - 23411270

Need to extract the following:

23411268
23411269
23411270

These numbers have to be listed in three seperate rows.

## For Loop Goes Into An Infinite Loop

Apr 8, 2007

My code below goes into an infinite loop, with culprit line shown in bold and underline...

## Index Function - Data Identified Based On A List Of Account Numbers And Return This Data To A New Sheet

May 8, 2007

I have a multiple column spreadsheet (Call it- "Money") whereby I need the data identified based on a list of account numbers and return this data to a new sheet.

In "Money" I have:

IE; columns B, C respectively have cust #A100 & 20.00
columns E, F respectively have cust #B100 & 40.00
columns G,H respectively have cust #C100 & 60.00
Etc.

(above for illustration-there are 100 lines of data in these columns with varied account numbers and respective dollars)

So what I have now is a new sheet I have named "Control". I have listed all my account numbers like A100,B100 etc. in column A. These are the account numbers for ident purposes.

I need the data entered in "Money" identified by those columns B,E,G with respective amounts from C,F,H and based on the list I have in "Control" whereby in "Control" if A100 is listed in column A then the figure to be returned in column B is all the data bits found in all columns C,F,H from the entire sheet "Money". Tough to explain but ie below....

## Find Whole Numbers In Row Of Data?

Apr 9, 2014

##UPDATED## Hello

understanding the IF forumlas to calculate rows with whole numbers in them for the last columns

CBOOK1.xlsxBOOK1.xlsx

## Sum Last Numbers In A String Of Data

Mar 31, 2014

I maintain a spreadsheet to track monthly sales of a few thousand items (see attached sample data). I'd like to have a formula that would sum only the last 12 months in the range of data. It would need to ignore all of the data before and the blank cells after the 12 months.

It's difficult to update the range each month for all of the products.

## Data Validation - Whole Numbers

Oct 2, 2007

how can I set a cell so that you can only type in 1 , 2 , 3, 4, 5

I know I can use the validation but people can just copy a cell and paste it over.

## Data Validation Allow Numbers Only

May 11, 2013

The numbers will be both negative and positive just need to catch characters.

So:

2500 is okay
-15 is okay
is not okay.

## Swap Numbers Or Data Around

Jul 30, 2013

I have let say column A and I have the date and name John 1913 all the way down to John 1940.

But what I need is a way to turn it around so A1 starts with John 1940 down to 1913.? If I drag down it counts up but I want it to count down if that makes sense.?

## Keep Data Entry Between 2 Numbers

Aug 24, 2006

I need to have a message box appear if a user tries to enter a value not between 992200000 and 992299999 in the range B11:B1182. I used the following code to test this out (only for B11).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B11").Value < 0 Then
If Range("B11").Value < 992200000 Or Range("B11").Value > 992299999 Then
MsgBox "Please enter the Associate ID"
End If
End If
End Sub

The problem is A: I need to apply this to every cell in the aforementioned range. And B: I need to only restrict this when there is a number in the cell (I tried to add the first If statement to do that, but it didn't work).

## Data Validation :: Letters Followed By Numbers

Sep 4, 2009

I currently have cell B3 in a worksheet - able to except 2 data entries.

The user should enter either OPQ or BOT followed by numbers. How do i ensure that they only enter OPQ (O - Letter Not Number) followed by numbers, or BOT (O - Letter Not Number) followed by numbers.

i.e. OPQ87654321 NOT 0PQ87654321 or BOT12345678 NOT B0T12345678. The information has to be entered manually and not via drop down list as each number is unique to the OPQ or BOT.

## Trying To Get Excel To Recognize Data As Numbers

Sep 25, 2013

I am trying to take a report that I can run and paste the data into excel. It is basically the same as if I went to a web page, and pasted some data into excel. Technically it pastes everything into 1 cell but I am able to break it up using Text to columns. The problem is that I have been unable to get excel to recognize the data as anything other than text (I.E, numbers and numbers and dates as dates). I've tried formatting cells and removing spaces.

## Trimming Data To Get Rid Of Spaces Between Numbers

Feb 6, 2013

I have a credit card number problem where I am trying to trim the data so that I get rid of the spaces between the numbers (number sequence look like this: 5999 9999 9999 9999. This is currently formatted as text, and I would like to maintain this as text and not convert it to a number. The trim function can't seem to get rid of the spaces.

## Data Validation Letters And Numbers

Apr 4, 2013

I want to create data validation so that the first 2 digits=PS and the next 4 digits will be numbers. I have tried a few things but I cant get anything to work?

## Data Validation: Allow Between 2 Numbers & Text

Nov 22, 2006

Is it possible to force a cell entry (using Data Validation) to either a whole number or a value? In other words, I would like the data in a cell to be either a whole number between 10,000 and 20,000 or "N/A". I can do it with VBA, but Data Validation (if it's possible) would be better.

## Data Validation For Dynamic Numbers

Dec 2, 2006

I am looking for a solution for my problem: I work for a bus company, I need a spreadsheet where I will record the bus numbers into a sheet but I only want to be able to add the number once ie. error if duplicate bus entered. Also the numbers will change from time to time, old buses sold when new ones arrive. I have the following code that someone helped me with wich works fine provided you don't have to change the numbers.

=And(Or(And(E42>=121,E42<=125),And(E42>=149,E42<=156),And(E42>=320,E42<=363),And(E42>=700,E42<=799),And(E42>=800,E42<=991)), COUNTIF(\$B\$3:\$E\$46,E42)<2)

## Data Validation With Negative Numbers

Jun 29, 2007

I want to use Data Validation on a cell (H1) to only allow the value entered to be values between values in E1 and D1. E1 is a negative number.I tried naming E1 & D1 as a range (valid) and then did custom validation formula is =valid, but that allows me to put in anything.

## Charting 2 Data Series With Different Numbers Of Points

Jun 12, 2014

Have Series 1 (to be a line chart) with 20 data points X values are 0 to 68. Have Series 2 (Bar chart) with 68 data points, again X values 0 to 68

Cant get series 1 to display beyond X value of 20

## Average Numbers Based On Other Two Columns Of Data

Jan 23, 2014

I have three columns of data, one containing numerical values. I want to average the numbers based on the other two columns of data. Attached is an example file with the desired output I'd like. What is a formula that will do this?
AverageExample.xlsx

## Cleanup Telephone Numbers Have Some Text Data?

Aug 16, 2014

I have some cells which contain telephone number and some text data. They look like this.

(713) 555-4600 (Work)
(713) 555-4620 (Home)
(832) 555-4610 (John's Phone)

I need to strip out the text data and just display the phone number as follows

(713) 555-4600
(713) 555-4620
(832) 555-4610

## Sum A Selection Of The Highest Numbers In A Range Of Data

Jan 29, 2007

I need to know how I can create a formula which will sum a selection of the highest numbers in a range of data. So for example, if I have a row of 10 cells each containing dfferent numbers, and I want to take the 7 highest values from there and get the sum of these values, how do I go about this?

I've tried using the LARGE command but can only get an individual figure.

## Insert Numbers Before Data In Multiple Rows

Jan 7, 2009

I have a string of numbers ex. 1234, 5678, 91011 in 400 rows. Before each string I would like to add 88.

## Require 2 Numbers Before A Decimal In Data Validation?

Feb 16, 2012

How can I require 2 numbers before a decimal in data validation? I have a formula to require at least to characters after.

I'd like to require the user to enter at least ##.##

## Data In Column - Extracting Text And Numbers

Jul 14, 2012

I have the following data in column b and I would like to extract into individual cells.

I would like to extract upto the first number, number text after first number etc

I have several rows and the data lengths are variable

Liverpool FC 2 Sheffield United 1
Manchester United 0 Everton FC 3
Middlesbrough 2 Manchester City 0
Norwich City 2 Chelsea FC 1
Oldham Athletic 1 Crystal Palace 1
Queens Park Rangers 3 Southampton 1

Copyrights 2005-15 www.BigResource.com, All rights reserved