Writing is perhaps the greatest of human inventions, binding together people who never knew each other, citizens of distant epochs. Books break the shackles of time. A book is proof that humans are capable of magic.
QUESTION: The problem with that, is that, this is something I need to do to an existing spreadsheet. Is excel capable of recognizing text within a column while disregarding some text? The column that I described above has numerous combinations of HALFBATH:1;FP:1;AC:SPLIT SYSTEM;POOL:CONCRETE;Sewer:PUBLIC;. Sometimes the values are repeated in the same order. Would I have to create a specific If/Then for each possible combination? Could I instead export that section to another excel file, save it as a .txt file, re-open as a CSV (so all the values are seperated) then use a single formula for each column totaling them up. Answer from Richard Rost:
Yes, you'd have to create a separate column to check for "POOL:CONCRETE" and then "POOL:VINYL". This might not be the BEST way to do it, but it will work.
The BEST way to handle this would be to break down every variable and store the information in a database like Microsoft Access. That will probably require some programming (to parse your data into something usable), but it will give you the best end result.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
