Page 1
Page 1
Started By
Message

excel question

Posted on 5/5/22 at 5:24 pm
Posted by Sir Drinksalot
Member since Aug 2005
16822 posts
Posted on 5/5/22 at 5:24 pm
I am doing a label merge to keep track of years that customers have purchased different items. There are 30 items. Some customers have purchased 1, some have 30. I want the la

I want it to say on the label "X has purchased A for _ years", "X has purchased B for _ years, etc"


in one column there are numbers, but not every cell has a number because not every customer has purchased that item.

in the next column I used:

=IF(ISBLANK(I10), "","has purchased X " & I10 & " years,") so that the cell will only populate with the wording if there is a number next to it.

the problem is that now there are cells that say "blah blah 1 years"

I tried to use the find/replace to find "1 years" and replace with "1 year" but it won't let me.

Anyone have any ideas?
Posted by mdomingue
Lafayette, LA
Member since Nov 2010
37836 posts
Posted on 5/5/22 at 6:17 pm to
You can next functions

quote:

=IF(ISBLANK(I10), "","has purchased X " & I10 & " years,")


=IF(ISBLANK(I10), "",IF(I10=1,"has purchased X " & I10 & " year,","has purchased X " & I10 & " years,"))

Or use year(s) instead of year
Posted by dakarx
Member since Sep 2018
7839 posts
Posted on 5/5/22 at 6:51 pm to
Why would you not put this into a database instead of a spreadsheet?

Believe it or not this is a serious question, from someone who doesn't use spreadsheets for much of anything...but I use the hell out of MySQL, MariaDB, Postgres, Oracle, etc...

Posted by mdomingue
Lafayette, LA
Member since Nov 2010
37836 posts
Posted on 5/5/22 at 6:58 pm to
quote:

Why would you not put this into a database instead of a spreadsheet?


I am assuming they do not have database software setup there?

first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on X, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookXInstagram