I am no geek when it comes to sheets, most of the stuff I do comes from watching a video on youtube. I have a retail booth at a flea market and I get my items from various resources, Some items come from estates that I buy, some from garage sales, some from a local auction house etc. I use the cents in the pricing to help identify where the items were purchased. For an estate sale, the price would be, for example, 10.31, so I can look at the daily sales report and immediately identify every item sold ending in .31came from the estate sale. What I’m wanting to do is list the different sources I use and have sheets track and total each item based up the cents. So in the Cell that has a heading Estate Sales, create a sum formula with the criteria of searching the sales report looking for every item sold that ended .31 Thanks in advance for the replies. If this isn’t possible, is there a way to copy and paste selected random cells. When I highlight multiple cells using the ctrl tab, click copy, then try right clicking paste, the cells don’t stay highlighted and I can’t paste.
Question
Is there a formula to sort cell items based upon the decimal value?
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
