Formula not just quite right

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

This formula is not just right


=(SUBSTITUTE(TRIM(BP77&" "&BQ77),"",",")&" "&(TRIM(BW77))&"
"&(SUBSTITUTE(TRIM(CJ77&" "&CK77),"",",")&" "&(TRIM(BW77))))

When all cells contain date it should display
B10 B12 B5 C2 B8 D11

but instead it displays
B10 B12 B5 C2 B8 B5

B5 at the end seems to be repeated and replaces D11

Anyone know what is wrong?

Pat
 
That's because you're pulling in the same cell, BW77,
twice. Change the last cell reference in the formula from
BW77 to whatever it needs to be.

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
Stripe out duplicate data 5
VLookup formula question 2
Formula to replace a Pivot table function 4
Difficult Formula 9
Formula Cell color limitation 7
finding a name in a string 1
Fill Series only changing one input 2

Back
Top