u/cmal
Just a head's up for those with a Safeway, they currently have a coupon for Nature Nate's honey - $8.00 off of the 32oz honey (sale price $11.99) with a limit of three. $10.00 off of the 32oz organic honey (sale price $12.99) with a limit of three. Sale price good through March 28.
I haven't checked Albertson's but they might have the same deal. Might be worth taking a look at your local store.
I have a small 1 year old camellia sinensis that I am training into a potted shrub. It has come in for the winter and started dropping leaves, to be expected. Unfortunately I cannot find any information online for wintering the plant and was curious if anyone had any advice or experience beyond the basics of controlling water.
I am using a formula to match a cell in an x and y array based on two input with column and row matching specific numbers. Formula is as follows:
=INDEX(range:range,MATCH(rowinput,rowrange,0),MATCH(columninput,columnrange,0))
Formula works perfectly with the column input set to equal a cell (columninput=target) but the row input breaks and returns a value not available error if I set it to equal cell (rowinput=target) OR copy and paste a value into the cell. Works perfectly if the value is keyed in manually. If I set the match to less than, it will return the previous row.
All cells are formatted identically. What am I missing?
Would really like to pick up the ones listed but happy to add most!
I have an online workbook that we use as an order sheet and I am trying to automate printing on ONLY the sheets that have been updated that week.
Simple =if() formula on the sheet recognizes if an order has been placed and returns a 1 in the cell if the sum of the order sheet is greater than zero and a zero otherwise. Weekly copy is downloaded and a macro opens the downloaded book, copies the information needed, pastes it to a production sheet, AND converts the =if() formula into values so the cell reads only 1 or 0, not =if().
What I would like to do at this point is get the SAME macro (easy enough for me to edit, no help needed there) to read that binary (cell A1 for this case) and print
Last year I cut up a section of sod, flipped it over, and turned a portion of our lawn into a small garden (7'x21' give or take) with all of the regular first year blues. Summer squash grew well, radishes did ok, turnips did ok, peas did ok, potatoes and tomatoes failed completely but they were very late going in. Cleared everything in the fall and put down about 4 inches of very well rotted horse manure from the back of a covered stall and covered everything with a layer of burlap. No odor emitting from the manure other than dust.
After a very wet spring, tilled in the manure and planted rows of carrots, radishes, beets and kale as well as some potatoes. Radishes and kale have done excelle
I am currently running into issues when trying to reference information stored in a workbook uploaded to onedrive and using that information to update information on onsite workbooks.
Any links that are formed are broken as soon as the information is updated and returns a #REF! error when using a simple right click, paste link option. Reference looks good in the formula bar. Is there a better method to make this connection? Is it possible?
I have been making peasant style hearth breads for a while, didn't remember how hard it is to make a nice looking sandwich loaf.
