I created a scorecard in excel that imports data for a data source. A dropdown list is on created of different employee names through Data Validation from this imported data. Most days everything is fine but if the data gets refreshed when there was an issue with the data, and […]
Daily Archives: September 8, 2021
12 posts
I am trying to use INDIRECT to dynamically reference another spreadsheet, but I am getting a ref error. The formula that I am using is =INDIRECT("'"&B3&"["&B4&"]Assignment Grades'!E10"). When I take the input to INDIRECT and throw an equals sign in front of it, I get this as the output: 'c:usersahmeedownloads[MATH_110_Homework_1_scores.xlsx]Assignment […]
I have a ThinkPad e508 running Windows 10 Home x64. I have been experiencing these strange issues where there is no audio coming out from the laptop speakers. Plugging in headphones using the headphone jack works fine though. The laptop’s current audio driver is Conexant audio driver 8.66.88.62. When I […]