m1973

Hi Richard

Regarding your question to my query

For example, what I’m looking for is, sheet 1 is the master sheet and what ever data is added into columns A & B on the main page is automatically copied into columns A&B in sheet 2. Again, whatever is added to column C&D (on the main page) is copied to columns A&B in sheet 2, and so on….
I need it to copy, say if I change the font colour to red or make the text bold on the master sheet that this copies to the relevant other pages?

Hope it makes sense

Many thanks

Richard M

/m1983

Hello Lou

=SUMPRODUCT((($G$5:$G$9)>=E12)*(($G$5:$G$9)<F12))

Assuming data is in G5:G9 and E12 is the lower limit and F12 is the upper limit of one of your pairs of limits.
Copy the formula as you need.

I'm not sure how your data is recorded but this should be easily changed to work for you.

I am looking for a formula to help me count a range of cells containing time.

I need to be able to break down the range in the following catagories and count the occurances between each time range;

0600 - 1200
1201 - 1800
1801 - 2400
0001 - 0559

FUCK U ALL

/M1980

Hello Morgan

How and where are the prices stored.

Ok I need some help..I am trying to have excel do an automatic entry for me Example: select a product from a drop down list and have excel automatically put in the price in the next cell. How do I do this?

In A3 enter

=MIN(A1,A2)


>
< replied-to message removed by QT >

I am working with ratios. I do not want a number to exceed two different ratios.

Which function would I use?

Joshua,

=IF(A1<A2,A1,A2) would be a simple way to do it.

GMc

< replied-to message removed by QT >

If you have 2 #'s in different cells and your want the lessor number of the two in another cell. How would you do that.

i.e. A1= 5 A2= 6 How could I create a formula that would take the lessor of A1 and A2 which is 5 and make it automatically show up in A3 which would = 5?

Joshua

I came up with the solution to my question. (#1971 below)

I used =IF(ISERROR(MATCH(LBID,LineBuyID,0)),"",MATCH(LBID,LineBuyID,0)) to get the row number of the first occurrence and then =IF(ISERROR(MATCH(LBID,OFFSET(LineBuyID,A3,0,ROWS(LineBuyID)-A3,1),0)+A3),"",MATCH(LBID,OFFSET(LineBuyID,A3,0,ROWS(LineBuyID)-A3,1),0)+A3) copied down 25 rows for the row numbers of the remaining entries.

Then =IF(ISERROR(INDEX(PSCtlNum,A3)),"",INDEX(PSCtlNum,A3)) in the adjacent cells in column B.

Thanks,

/m1973

If you are copy and pasting, try the options in Paste Special.

If not, how are you linking the files?

HTH

Hi,
I am trying to create a spreadsheet. linked with information from a master spreadsheet. The spreadsheet contains only text but I need it to copy the colour and text format from the master sheet. At present I can only get the text to transfer as standard.

Thanks

Hi All,I have columns, A to D with data containing daily despatch times, all acending through 24hrs.
I want to average each time in the columns and match this to a timeline with a tolerance of + or - 15 mins.
There may be several average despatches at say 10:00, these all need to be shown against the timeline.
Hope this makes sense and you can help
Thanks.

I have a worksheet named DATA with data in columns A thru E. The data is sorted by column A. There can be from 1 to 20 rows with the same value in column A. I have another worksheet named REPORT to display selected data based on the value in column A of the DATA sheet. The row headings are the same on both sheets. I want to be able to enter a value in a cell on the REPORT sheet and load all the rows from the DATA sheet that match that value.
I ran across a method of doing this a few months ago and had a sample workbook but have been unable to locat it (probably deleted in one of my cleaning binges). I believe it used INDEX, MATCH, INDIRECT and ROW functions.
Thanks,

hi HTH,

i just found that, if i had created the necessary worksheets and databases - in 1 of my worksheet, i just have to edit 1 cell on the [source] name to the relative database name. In the edit, links, i could now see the relative database. And i could toggle the update from there. :)

but i cant remember what i did just by toggling with this changing source,updating,.... i could actually change the rest of cells [source] name reading from the relative database.

i tried to do so again, but it couldnt work. You have any idea how to do about it ?? :p