User Profile
williamdhicks
Copper Contributor
Joined Feb 06, 2023
User Widgets
Recent Discussions
Re: Extract Attribute (column name) from data living in a cell
The final output would be a formula to create that paragraph in the future, so that you could see what was in it and gather all the data in those columns to create it. Basically you have a description ( a paragraph) and you are trying to extract the attributes (the columns), so in the future you can recreate that description (with the formula) Example: By seeing the Output Formula, and using the one in the To Recreate Formula, I can now create the paragraph in the Dog row. (also by seeing al the Output Formulas for the column, I can decide which one is correct for that group of items): Col A Col B Col C Paragraph Output Formula To Recreate Formula Cat 10 lbs. Diabetes Cat, 10 lbs., Diabetes Col A, Col B, Col C A&,", "&B&", "&C Dog 24 lbs. Broken Leg Col A, Col B, Col C1.9KViews0likes1CommentRe: Extract Attribute (column name) from data living in a cell
I'm trying to figure out if I have a paragraph of data...if the data in one cell of the column is in it...and then if it is, capture that column header, so I can backward out a formula to create that paragraph for other cells. Hope that makes sense.2KViews0likes3CommentsRe: Sort fractions within a cell in Excel
no, that was just a sample, to show the kind of text that might appear. It's not likely to have mixed units. sometimes it's a list of items--e.g. 1 of this, 2 of that, 3 of that. If you want something more complicated look at my other question about how to backward out data into what columns it exists in (and create the list of column headers from that). It would be great if that can do look at a range and do that.1.1KViews0likes3CommentsRe: Sort fractions within a cell in Excel
This works great for most of my situations..but since you seem to be an expert in Excel...maybe you can help with these oddball sitatuions> Sometimes it's a mix with a comma or a blank--that doesn't pull the data (the last value for exampled would not have anything) ....or it has words in the string. Is there any possible fixes for those situations?3.3KViews0likes7CommentsExtract Attribute (column name) from data living in a cell
I'm trying to create a backwards formula (extraction): That will find the attribute (column name)in a All Columns value (based on data in a created formula.) For example, Column 1 Column 2 Column 3 Column 4 All Columns Backward Formula Extraction 25 feet. 2 towels Black No value 2 Towels, Black Column 1, Column 2, Column 3, Column 42.3KViews0likes6CommentsSort fractions within a cell in Excel
I am trying to sort data within a cell (not a column/row) ...and it's in fractions. As an example, I have this in one cell: 1/2;1-1/8;22-12/18;1/8;1/22; I want it reorder the data in the correct small to larger order to this: 1/22;1/8;1/2;1-1/8;22-12/18; Is there a formula to do this (not a text to cell, or5.4KViews0likes26Comments
Recent Blog Articles
No content to show