Forum Discussion
Diabetic Searches in Excel.
Basic point, though, a database in Excel is typically based on rows of data for days, or for days and times.....without lots of blank spaces. Your A1c original has blank spaces predominating over data.
Maybe I need to attach as file not post as image. See attachment.
I completed late last night. I put field on daily and referenced from other monthly a1c. Dropdowns are too time consuming.
mathetes, My comment was not to be taken personally. I hear your comments about validation but my data is not fixed and the sheet WILL change in the future. Formulas I can update faster. Dropdowns must be individually edit. I made changes to hundreds of sheets at the same time with formulas, I cannot do that with dropdowns in Excel...yet.
Try this. I disagree with you regarding drop downs. They make for consistency--via their "data validation" usage; as I've done here they save a lot of space (file space). If consistency doesn't matter, but you still want to record time of testing to some degree of precision, you could just enter per your own comfort.
Anyway, it's your database, so do what seems right to you. Best wishes for controlling your condition.