Splitting Array Elements into Multiple Elements
I am trying to extract an array from a column of a table. The column is text only and some cells have multiple values separated by semicolons. I am trying to extract an array that has a separate item per array element. Using this formula, I get an array where each cell in the table column is an element of the single column array with duplicates removed and sorted alphabetically. =SORT(UNIQUE(GPO[about:config setting equivalent],FALSE,TRUE)) This is one of the elements in the array but it is three values separated by the two semicolons. browser.download.dir;browser.download.folderList;browser.download.useDownloadDir There are many elements that have only one value but there are others that have two, three, four, or more values. Is there a way that elements with multiple values can be split so each value is a separate element? My best guess it that it is a function that operates on the GPO[about:config setting equivalent] array within the UNIQUE function. I just have no clue as to what that function would be or even if such a function exists. Each value contains no whitespace and it is not difficult to change the delimiter from a semicolon to a space or a comma if necessary.
Date of Last Modified for a Cell
Good day, all. I am inquiring if there is an excel function that would give me a date (and time) that an individual cell was last modified. For example: cell A2 has an entry of $2.55 and I'd like cell A3 to read "12/5/22 at 10am". a week later I change the $2.55 to $3.00....I'd like the A3 cell to read "12/12/22 at 10:30am". I've seen some VBA solutions but wondering if there is a simple excel formula to accomplish this?
Excel doesn't calculate time (#value error) when past 13:00.
I need help to correct an #value error. My calculations work perfectly fine when I subtract one time cell from another except when the time is past 13:00. I tried changing the cell function to general, number, custom but nothing seems to work unless I manually change the time to 1:00pm. Thoughts? TIA Below is an example: Cell AB Cell AD 8:15 08:29 AM 0:14 13:06 PM 13:54 PM #VALUE! =SUM(AD2-AB2) is the formula I am using
Formula instead of Value
I am sent a spreadsheet every month that I need to use to calculate values. I put my formula in the cell: if (e2=0,7.25,e2*7.25). When I hit enter, nothing happens. The cell just shows the formula. My guess is there is a setting somewhere in this particular worksheet that causes this to happen, but I am unable to find it. I have a deadline, so SOS ASAP. Thanks!
