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!
Counting text only once within date range
Hello, I'm struggling to create a formula that will count text within a column only once, but also falls within a certain date range i.e. 01/01/2025 - 31/01/2025. I'm able to create the formula to either count the text once or to look up date within the given date range, but I don't know how to make them work together. Can someone help me create something, please? This is an example spreadsheet, as I can't post the actual one due to confidentiality, but I'd like the formula to tell me how many clinical areas we have during 2025, for example. So the answer using this example should be 2. Please let me know if you need more information to help me! Thank you :-)
Complex Cell Format, Maybe!!!
Hi, I'm in the eyecare profession and we make use of vision measurement (visual acuity) standards, and these are supposed to be indivisible fractions, but here are what I's faced with: Unless I format the cell to text, excel will either divide the fraction or convert it to date via the date picker I'm using what other means can I use? I'd like to use this fraction like 6/18 or 20/60 to count in the count function, would this be possible? This is just the start, I want to solve this first and then see how it goes. Thanks for your guidance. Cheers.Outline not showing + and -
 When I use the Outline function in the data tab, I select a couple of columns. But the + and - sign that should come up above the column does not. I only get a small mark at one of the columns and I have circled it in the image I have attached. How do I get the default view back? I have already checked File -> Options -> Advanced -> Show options for this workbook / worksheet: Show outline symbols if an outline has been applied -> checkmark!
