Forum Widgets
Latest Discussions
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...)Creating connections to import CSV files into excel 365
Hi, I'm upgrading from a much older version of excel (2013) and realize I had to delete all my old import connections because the new version kept telling me they were blank. Starting from scratch, I'm trying to import csv data extracted from web pages into my worksheets into existing sheets. I've only been able to manually import one sheet at a time and each time, it creates a new sheet instead of flowing into the one I intend it too. When I try to create or edit the connections, the "properties" button is greyed out. In the older version, I was just able to tell excel where to get the information from and where to put it. Why is this so much more difficult? Microsoft support already had me edit a lot of stuff in the Trust Center to enable and allow everything. Seems no help at all. Matt
The Image function messed up my spreadsheet and I cannot remove it
I have an old spreadsheet that has worked well for over two years. Feeling confident, I want to add some photos this year and I looked into Image(). I put the photos (JPG) on ImageKit and put the URL in an Image function in one sheet. Seems to have worked fine. Then I tried to use a cell reference in another sheet to get the Image from the original sheet. Then I read that won't work so I want to remove that column. But now I get 3 different error messages, one of which says the worksheet is broken. This file is on DropBox because it is used by different committee members. I have tried all the repair buttons that come up and none have worked. I'd be happy to give up on the Image() function if I could just get back to the way it was before I started using Image(). I do not have a backup of the file. Any help and suggestions are appreciated. Thanks - Joe
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!
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)
