Change count range vs cell value!
hi exceler's,
need some help, should to easy I think!
How do I change the count range (row height) base on a cell value.
To forward explain it please see the image below, if you need more info will do, but this should be easy:
http://img689.imageshack.us/img689/6239/picvja.jpg
Uploaded with ImageShack.us
Hi,
We always like to see your request in context, pictures are not really much use, non of us wish to recreate a workbook which you already have. Please therefore upload the workbook,
Show a before and after example in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
thanks Richard,
here is the book
http://www.xysoft.com/Book1.xlsx
hope that helps
Last edited by stewart08; 08-18-2011 at 01:18 PM.
Hello Stewart.
The workbook is fine but I don't understand what you are trying to achieve. I'm assuming what you have is the before position but you've not shown what the 'after' position is.
You also mentioned row height and count range in the same breath. I don't understand. Please show what you expect to see along with some narrative as to how you arrive at the result.
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
Richard
here are some narrative:
http://img689.imageshack.us/img689/6239/picvja.jpg
Sorry Stewart, that's just the picture you started out with. It doesn't explain, (to me at least) what exactly you expect from your data. Please supply a before and after position with notes as to how you get from one to the other.
Remember, whilst you may be totally au fait with your data, we come to this afresh. You need to explain a lot more.
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
ok, I will try to simplify the question; is it possible to alter the range of a count function via an other value, ie
A1:A3 has 3 2s:
2
2
2
B1 cell value is 3
the count funtion counts 3 rows (A1:A3) resulting in "6"
if B1 cell value is 2
the count funtion counts 2 rows (A1:A3) resulting in "4" etc...
=sum(a1:index(a:a, b1))
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
shg this is helpful, but I need the count in the oppsite direction (going up) see image http://img689.imageshack.us/img689/6239/picvja.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks