Thanks so much. It works perfectly
Its funny that after posting on chandoo.org, i was then able to write a code to perform the task
see https://docs.google.com/open?id=0B32orugVlNhDT01UeGtsMGhkMmc
See Module 3 in the attached file for the Macro I wrote
I really appreciate this.
Thanks...
I have a spreadsheet that has all the data in column A. A special character "|" marks the end of an entry, all entries dont have same number of rows. What i want to do is to copy rows inbetween two "|" characters and paste transposed on another sheet.
See sample worksheet in...
I could not open your sample file maybe thats where the mix up is coming from.
In my smaple sheet, when i put a room number as 3, it fills the data in row 2, room number 4, fills data in row 4.
Maybe you could explain again.
You ate definitely right about the value in D15, pasted in ahurry.
I agree with your suggestion on not using VBA, i only wanted to see how it could be done with it. Are you familiar with ACL(Audit command language). Performing a similar task must be done with a script, so i only wanted to see...
If I understand you correctly,you want every cell in that range to be equal the minimum in that range.
You can write in colum B: =min($A$1:$A$5)
Let me know if this meets your needs
Sample data would have been good. You said sum the corresponding cell in that row, sum it to what please?
Try using a sumif if you just need an overall sum.
=sumif(S1:S31,"JOHN BLUE",A1:A31)
Please let me know if this meets ur needs
See the spreadsheet in the link below.
I want to do a running balance for each account.
When the account changes, the sum is reset and continues to sum up till it gets to the next change in account.
the link is...
HI Narayan,
You are simply amazing.
It works except when there's a tie which is good itself
I have not been able to wrap my head around the magic going on there so if you could break the formula down a bit, that would be fine.
Faseeh,
Thanks for your observation.
Iknow its not full proof but I would like to at least be able to return one of them, i probably would then think of extending it to accomodate ties
Narayank/Cyril
I am sorry about the permission thingy, I have modified the access.
https://docs.google.com/spreadsheet/ccc?key=0An2orugVlNhDdEV4R1owbFk4Z1RSY19KbWd3TENSRHc&pli=1#gid=0
Sorry for the inconvenience
Hi Narayank,
Pls try this
https://docs.google.com/spreadsheet/ccc?key=0An2orugVlNhDdEV4R1owbFk4Z1RSY19KbWd3TENSRHc&pli=1#gid=0
What I need is to rreturn the player name that appears most frequently for each club
I have a list wth player names and their clubs. I have a dropdown in another sheet from which I select the club whose records i want to see. I want to be able to select a club and with a formula to know whose name appears most frequently in the list.
See sample workbook in...
Thanks so much for the explanations.
What prevents the collection from not accepting same Cstr(R)?
That was the part that made me ask for explanations in the first place.
Please I need help creating a function that can shuffle the characters of a word.
e.g Peak as kepa, faithful as thfaiutl
Trust that the gurus would solve it
From what i see LARGE,MIN and SMALL dont seem to work when the cell is blank like you rightly put it. So it seems iferror would come in handy or some other IF statements.
SO the formula in my last post profuces an error
very well said. Will digest your comments later.
So we could just use large(E7:G7,3) in place of min.
Then we have =MAX(LARGE(E7:G7,3),LARGE(H7:J7,2),K7,L7,M7)