LinkBack URL
About LinkBacks
Hi, Could someone help me get a formula to get column C? Thanks!
Book3.xlsx
Capture.JPG
Hi, Could someone help me get a formula to get column C? Thanks!
Book3.xlsx
Capture.JPG
Last edited by cs02; 08-10-2015 at 11:35 AM.
Hello
Try the following formula in column C:
Formula:
Please Login or Register to view this content.
DBY
In C2 copied down
=IF(A2=A1, C1-B2, A2)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi, thanks - that partially works, but it doesn't start fresh when the values change to 192 from 41!
Hi
Didn't see the extra screenshot originally, try:
Formula:Please Login or Register to view this content.
Last edited by DBY; 08-10-2015 at 12:13 PM.
Doesn't my formula work?
You didn't mention changing values in column A but I suspected that would be the case. Try this:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
All answers work! Thanks for your help
If Id like to find the value of column A corresponding to only the first negative value- how can I do that? So say in Column D, I'd like to have the value of Column A only when I hit -1 in column C and so on..
Hi
Thank you for the Rep mark, try in column D:
Formula:Please Login or Register to view this content.
DBY
This works perfectly fine!! Thanks a bunch!
Yes, that's basically it. It counts the number of times the value in column A appears with a negative value in column C. When the count is 1, it returns the A value else it returns a blank "".
Perfect! Thanks again
Hi, this formula =A2-SUMIF($A$2:A2,A2,$B$2:B2) doesn't work when the same range of values appear again in column A. For example if 41 appears again after 192, it counts the values in column C corresponding to the older decrementing values for 41. How can we change this formula to start fresh every time?
Last edited by cs02; 08-11-2015 at 02:03 PM.
Hi
I think with a slight amendment to ChemistB's formula:
Formula:Please Login or Register to view this content.
This seems to work. Try it out in C2 down. Kudos ChemistB!
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks