Forum Widgets
Latest Discussions
Hyperlink doesn't stay in the same row as the data in my Table
I made a worksheet with Dynamic search box using FILTER function and made another worksheet that has the Masterlist, i need to hyperlink Certificate records of the hospital staff the Table but when i put it on the row of someone specific the data becomes a plain text on my search box. i tried also hyperlinking the file on the searchbox as well but the hyperlink stays on the same cell and doesn't follow the row it should be in.
Find Which Emp Number is Associated with Which Person in a Data Set
Good Day! I'm unsure which formula to use, I have a data set that shows First Name, Last Name, Emp Number, and Dates Attended that is auto generated by who shows up in any particular day. (See attached Pic#1) I would like a formula that breaks down which names are associated to each number. So, for example if I type in '6167' into a cell it will show 'Tom Rock' is associated with that number. (See attached Pic #2)
xlookup not finding number/letter mix
I have a column consisting of part numbers: a mix of numbers and digit/letter combos, e.g 2, 3, 3a, 4, 5, 6, 6a, 6b, 6c, 7, 8 ...... I have formatted both the source column and the lookup column as text. But xlookup() only finds the cells which have both digits and letters (i.e. 3a, 6a, 6b, 6c...)
Populating Schedule based on two Criteria
Hi There - I am working on a master schedule for a camp that will populate two sheets, one that has a full weekly schedule for all groups (this part I've figure out), and the second sheet (or multiple sheets) that will populate the activity schedule. Essentially, I have a master schedule and want to be able to pull two smaller data subsets from it, one by group, and the other by activity. I'm open to any and all changes to make this accessible, thank you! Below is the master schedule with data My group schedule (I can drag and it will fill in columns, so easy there), Any adjustments to master will repopulate Art Schedule, for example, that I want to set up to auto fill in, so any adjustment I make in the master schedule will reflect here. Thanks in advance for any help!Power Query by Default Excludes First Blank Column
I have researched this down the rabbit hole long enough without any answers. In Excel I created a Power Query Get Data from Sharepoint Folders using the Contents method. There are about 10 files where the data is in the same format, columns match sheets are all the same name, etc.... FYI, None of them are setup as Tables for reasons I won't go into. They just can't. When I import the files 5 of the files have data in column A while 5 do not. When I import the data the files that do not have data in column A Power Query is automatically removing those columns from those sheets. Which then screws up the column order when the data is appended and loaded to the table. How can I force Power Query to bring in Column A even if some files column A are blank?
