User Profile
SatyaGupta_In
Brass Contributor
Joined Mar 11, 2023
User Widgets
Recent Discussions
- 1.8KViews0likes0Comments
Re: ‘Enable Iterative Function’ Error
OliverScheurich I am not able to start a new discussion hence I had to start with a reply to similar problem by other communit member, sorry for that. am getting error message "XIRR attempted to compute the internal rate of return for a series of cash flows, but it was not able to" Please help Thanks in advance for your time and favour2KViews0likes6CommentsRe: Second to last value from table with condition
I'm interested in using Excel on both devices phone & laptop but once you upload files on Google drive and access them on any device other than from which it is uploaded, it will open by default on Google sheets. This is the precise reason that I have to use Google sheet when I open files on mobile phone3.5KViews0likes0CommentsRe: Second to last value from table with condition
Hi, I'm using the file on my Android phone through Google drive hence there are lots of limitations, therefore please suggest ways which may seemingly work on my laptop (where it is accessed through Excel) and on my Android phone (where it is accessed through Google sheets. Thanks PeterBartholomew14.1KViews0likes2CommentsRe: Second to last value from table with condition
Hi,My data rows are 1433 - 1788 but after applying above formula it is picking up results outside of this range. Anything further can be done or should I resort to old formula earlier suggested by you. Thanks in advance for your help OliverScheurich3.7KViews0likes3CommentsRe: Second to last value from table with condition
Thanks a lot for the help, however there are three adjacent rows to these value which are row numbers (circled in the attached screenshot) of these values, I hope these would also require changes in these formula OliverScheurich3.7KViews0likes6CommentsRe: Second to last value from table with condition
Hi, Once again I need your help. Infact my file has data in the rows above the data rows for which formula was applied. Because of this the row number keeps changing whenever I add some data rows. Is there any way that the row number in the formula keeps changing relative to the data range of the formula. The screenshot of the formula with the row number in question is circled as also the Excel file in which you earlier suggested the formula. Thanks in advance for your help. OliverScheurich3.7KViews0likes8CommentsRe: Second to last value from table with condition
Hi, Once again I need your help. In fact my file has data in the rows above the data rows for which formula was applied. Because of this the row number keeps changing as I continue to add some data. Is there any way that the row number in the formula keeps changing relative to the data range of the formula. The screenshot of row number in the formula is circled for your easy reference as also the Excel file in which you did suggest the formula. OliverScheurich3.7KViews0likes0CommentsRe: Second to last value from table with condition
Thank you very much, I was working on Office 365 but real problems seems to be working on Google Sheet. You are right criteria also needed to be changed which I did but forgot to mention that in my post. Thank you once again for your time & great help3.9KViews0likes0CommentsRe: Second to last value from table with condition
Thank you it worked, in fact I did on Google drive through mobile hence result was not being returned. Now I have done in Excel on Laptop it is working fine. However, what needs to be changed for obtaining second to last row number instead of last row number with same criteria.3.9KViews0likes0CommentsRe: Second to last value from table with condition
Thank you very much for taking great pain. I don't have enough kind words to express gratitude. I have copied the formula and changed the row numbers due to change in data in my file. The formula suggested by you is there in cell number J1793 (filed with yellow colour) but it is returning nothing. The cell I1793 contains the last value arrived at after applying two conditions on column L & M. The latest file is attached for doing the needful.OliverScheurich4KViews0likes3Comments
Recent Blog Articles
No content to show