This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.
I want to get a formula with COUNTIFS, like =COUNTIF(A1:A3,"<>"&"") such that when A1 = 2, A2 = "", …
excel excel-formula countif nonblankSo I have two cells, both referring to another sheet. One cell has the row of the other sheet and …
excel excel-formula worksheet-function excel-indirectInfo: Excel 2010 (no macros) Data Origns: MySQL Query / phpMyAdmin Server: Apache Code is run via: Server SQL Query (copy & …
excel excel-formula excel-2010 subtotalLet me explain. I have to do some fuzzy matching for a company, so ATM I use a levenshtein distance …
excel excel-formula levenshtein-distance fuzzy-logicI have a spreadsheet whereby on a monthly basis I need to return the top product based on a table …
excel excel-formula excel-matchI'd like to create a table lookup formula that matches two columns. For instance, suppose I'd like to find the …
database excel excel-formula lookup-tablesI need to convert a few hundred three letter country codes (ISO 3166-1 alpha-3) to their full country name in …
excel excel-formula vlookupI want to count empty (or non-blank) rows in a given column (or range). Example: I have a column which …
excel count excel-formula row nonblankI would like to sum a column between two dates, however the dates are in separate columns. I want the …
excel date excel-formula excel-2011I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am …
excel excel-formula excel-2013