Trending in Formulas and Functions
-
I can not figure out what is wrong with my CountIFs formula
I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$") It works great. However, I…
-
Importing Excel Files
Hi All! Does anyone know why sometimes it shows " ' " in a cell when an excel file is imported? I´m having a hard time when it happens because VLOOKUP formula cannot find the information ... Thank you & Regards, Camila
-
Retrieving parts of a text fields
Hi there, I have a project identifier column that includes a project code (111-AAA) and project name (client name). Ex: 123-ABC Disney Corp I would like to separate the Project Code and Project Name into 2 Columns, which will result in me having 3 columns Project Identifier, Project Code and Project Name. For the 'Project…