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 am using the following formula: =IFERROR(INDEX('Cleaned Post'!W:W,MATCH(Combined!$C2,'Cleaned Post'!$C:$C,0))," ") This …
excel excel-formula excel-matchI need an Excel function that can extract a string after last \ from a path and if no \ found then …
excel vba replace excel-formula find-replaceI have Excel Data like below JID Val 1001 22 1030 6 1031 14 1041 8 1001 3 2344 8 1030 8 2344 6 1041 8 How do i get the unique JID values like below using formula? …
excel-formula excel-2010Trying to decipher some Excel formulas and I see some stuff like SUMPRODUCT(--Left(...)...) What is the -- doing? Naturally …
excel excel-formulaIn excel 2007, I have a formula in a cell like the following: =COUNTIFS('2008-10-31'!$C:$C;">="&…
excel excel-formula worksheet-functionFor the following sheet: A 1 0 2 0 as formula result 3 0 4 0 as formula result 5 0 as formula result 6 blank 7 0 How do I count only …
excel excel-formula formula countifI'm trying to average a range of values if its associated date falls between two specified dates. The following function …
excel-formula sumifsI have a data set with publishers with revenue by month. Publishers are considered to be "active" month if their …
excel excel-formula dax powerbiI have a excel sheet(csv) like this one: and I want the output(tab delimited) to be like this: …
excel excel-formula excel-2010 worksheet-functionI am working with an excel file and I am trying to "map" some values with the vLookUp function. The …
excel formatting syntax-error excel-formula vlookup