- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
excel question
Posted on 5/5/22 at 5:24 pm
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?
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 on 5/5/22 at 6:17 pm to Sir Drinksalot
You can next functions
=IF(ISBLANK(I10), "",IF(I10=1,"has purchased X " & I10 & " year,","has purchased X " & I10 & " years,"))
Or use year(s) instead of year
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 on 5/5/22 at 6:51 pm to mdomingue
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...
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 on 5/5/22 at 6:58 pm to dakarx
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?
Popular
Back to top
