• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

last filled value and text in front of a formula

Hello Excel wizards,

On the 'Pay Dates' worksheet I have a list of dates. On my 'This Month' sheet in A2 I want the sheet to somehow show the last filled date from my 'Pay Dates' sheet. Ex. If my last entry on the 'Pay Dates' sheet is 9-Sep then I want 9-Sep to appear in 'This Month' A2

I want some text in the front of the formulas in A15, A16, A19, A20, A23, A24. I attempteded to use this formula to accomplish it but it did not keep the % after the text.

=CONCATENATE("Lifestyle: ",INDEX('Pay Dates'!$F:$F,MATCH('This Month'!$A2,'Pay Dates'!$A:$A,0)))

In A15 I want the text Lifestyle to go in front of the % so it reads Lifestyle: 20%
In A16 I want the text Essentials to go in front of the % so it reads Essentials 20%
and so on through A19, A20, A23, and A24

Thanks
 

Attachments

Hi Nebu,

Thank you. In A15 it maintained the 20% calculation but in A16 the formula was =1-A15. Same for A20. A24 doesn't want to behave either. When I updated worksheet came back with a bunch of value errors. See attached file
 

Attachments

Hi:

You were getting value errors because you were trying to multiply text with numbers once you concatenate any values excel will consider it as text. I have fixed the errors now.

Thanks
 

Attachments

Back
Top