Can anyone help me.

stone · May 15th, 2002, 07:45 AM

Hi guys.

I have a problem in excel, that i cant solve.
It is very hard to put it into words.

i think it could be solved by using sumif and countif togather.

so if anyone could please help me i could send it to you.

BK
Stulli
stulli77@hotmail.com

Aladin Akyurek · May 15th, 2002, 07:49 AM

Quote:

On 2002-05-15 06:45, stone wrote:
Hi guys.

I have a problem in excel, that i cant solve.
It is very hard to put it into words.

i think it could be solved by using sumif and countif togather.

so if anyone could please help me i could send it to you.

BK
Stulli
stulli77@hotmail.com

Try to word it though. The problem as well as, if a solution exists, its solution can be of interest to others.

Aladin

stone · May 15th, 2002, 08:03 AM

okey,

does this work

In column J you type on which floor the radiator(s) are(0=basement, 1= first floor ect)
in column K, you type how many radiators are in a specifig room on the corresponding floor.
Column J should give these radiators a number. (which Im trying to do)

I got this so far (in column J)
=(J24&IF(COUNTIF($J$24:J24,J24)>=10,COUNTIF($J$24:J24,J24),"0"&COUNTIF($J$24:J24,J24)))

this does nor take into account the values in column K (but it needs to do so).

Can you guys see the pattern ,how the "radiator number" is gotten?

please respond if you dont understand what Im trying to do.

BK
Stulli

[ This Message was edited by: stone on 2002-05-15 07:22 ]

[ This Message was edited by: stone on 2002-05-15 08:30 ]

[ This Message was edited by: stone on 2002-05-15 08:32 ]

[ This Message was edited by: stone on 2002-05-15 08:37 ]

Von Pookie · May 15th, 2002, 08:17 AM

You can not post pictures on your hard drive to the internet. For an explanation why, see this post, as I just don't feel like typing it all out again.

_________________
~*Kristy*~

"Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."

[ This Message was edited by: Von Pookie on 2002-05-15 07:18 ]

Chris Davison · May 15th, 2002, 08:38 AM

is this following on from your earlier radiator problem ?

http://www.mrexcel.com/board/viewtop...c=7377&forum=2

Aladin Akyurek · May 15th, 2002, 08:42 AM

In column I you type on which floor the radiator(s) are(0=basement, 1= first floor ect)
in column J, you type how many radiators are in a specifig room on the corresponding floor.
Column K should give these radiators a number. (which Im trying to do)

I got this so far (in column K)
=(I24&IF(COUNTIF($I$24:I24,I24)>=10,COUNTIF($I$24:I24,I24),"0"&COUNTIF($I$24:I24,I24)))

this does nor take into account the values in column J (but it needs to do so).

Can you guys see the pattern ,how the "radiator number" is gotten?

It seems you're trying to generate a radiator code.

If so, give an example of such a code and tell from which cells its parts must come.

stone · May 15th, 2002, 08:46 AM

Quote:

On 2002-05-15 07:38, Chris Davison wrote:
is this following on from your earlier radiator problem ?

yes cris it is, Im now trying to find out i can make the pictur visible (Im now trying to find free drives on the internet)

http://www.mrexcel.com/board/viewtop...c=7377&forum=2

stone · May 15th, 2002, 09:43 AM

HI AGAIN GUYS
I finally made it, you can see the picture now, right?

So, what do you think, is this possiple to do?

BK
Stulli

invisigirl · May 15th, 2002, 10:28 AM

This is off topic for the actual Excel question, but I could see both the picture here and the picture Von Pookie posted in the other thread, where she said, "It won't show up this way."

So, apparently, you guys are smarter than you think, or else I'm just more visionary than I thought.

Chris Davison · May 15th, 2002, 11:01 AM

Quote:

On 2002-05-15 09:28, invisigirl wrote:
This is off topic for the actual Excel question, but I could see both the picture here and the picture Von Pookie posted in the other thread, where she said, "It won't show up this way."

So, apparently, you guys are smarter than you think, or else I'm just more visionary than I thought.

sadly not.... Von Pookie's image is always visible, whereas Stone's original image wasn't, then he changed its scource and it became visible.... at which point you must have seen the whole thread....sorry !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 07:45 AM	#1
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Hi guys. I have a problem in excel, that i cant solve. It is very hard to put it into words. i think it could be solved by using sumif and countif togather. so if anyone could please help me i could send it to you. BK Stulli stulli77@hotmail.com

May 15th, 2002, 08:03 AM	#3
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	okey, does this work In column J you type on which floor the radiator(s) are(0=basement, 1= first floor ect) in column K, you type how many radiators are in a specifig room on the corresponding floor. Column J should give these radiators a number. (which Im trying to do) I got this so far (in column J) =(J24&IF(COUNTIF($J$24:J24,J24)>=10,COUNTIF($J$24:J24,J24),"0"&COUNTIF($J$24:J24,J24))) this does nor take into account the values in column K (but it needs to do so). Can you guys see the pattern ,how the "radiator number" is gotten? please respond if you dont understand what Im trying to do. BK Stulli [ This Message was edited by: stone on 2002-05-15 07:22 ] [ This Message was edited by: stone on 2002-05-15 08:30 ] [ This Message was edited by: stone on 2002-05-15 08:32 ] [ This Message was edited by: stone on 2002-05-15 08:37 ]

May 15th, 2002, 08:17 AM	#4
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	You can not post pictures on your hard drive to the internet. For an explanation why, see this post, as I just don't feel like typing it all out again. _________________ ~Kristy~ "Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam." [ This Message was edited by: Von Pookie on 2002-05-15 07:18 ]

May 15th, 2002, 08:38 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	is this following on from your earlier radiator problem ? http://www.mrexcel.com/board/viewtop...c=7377&forum=2

May 15th, 2002, 08:42 AM	#6
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	In column I you type on which floor the radiator(s) are(0=basement, 1= first floor ect) in column J, you type how many radiators are in a specifig room on the corresponding floor. Column K should give these radiators a number. (which Im trying to do) I got this so far (in column K) =(I24&IF(COUNTIF($I$24:I24,I24)>=10,COUNTIF($I$24:I24,I24),"0"&COUNTIF($I$24:I24,I24))) this does nor take into account the values in column J (but it needs to do so). Can you guys see the pattern ,how the "radiator number" is gotten? It seems you're trying to generate a radiator code. If so, give an example of such a code and tell from which cells its parts must come.

May 15th, 2002, 09:43 AM	#8
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	HI AGAIN GUYS I finally made it, you can see the picture now, right? So, what do you think, is this possiple to do? BK Stulli

May 15th, 2002, 10:28 AM	#9
invisigirl Board Regular Join Date: Mar 2002 Location: Oregon Posts: 130	This is off topic for the actual Excel question, but I could see both the picture here and the picture Von Pookie posted in the other thread, where she said, "It won't show up this way." So, apparently, you guys are smarter than you think, or else I'm just more visionary than I thought.