gave

Hi, i use these formulas quite a lot for looking up previous match is there a more efficient way? As these seem to slow everything down Formulas below are based on text data in column A, and values in Column B ​Lookup Column C =LOOKUP(2,1/($A$1:A2=A2),$B$1:B2) Someone on Reddit gave me this...

Hi All Sheet1 of my excel sheet has the below string in cell B1: <tbody> MATCH("PltStk",'C:\Users\kkumar\Desktop\ZPP AVL\[02JAN2018.xlsx]Sheet1'!$1:$1,0) I defined a name "Result" as = EVALUATE(Sheet1!$B1) In cell C1 I want the match function to be evaluated, so I gave below formula...

Hi All I want to index a column and match a criteria in multiple columns. I want to index column A and find a match in columns B:F I gave this a try =INDEX(A1:A20,MATCH(G1,B1:F20,0)) Thanks!

I have a table of donations given over several years, and need to generate a count for how many first time donors in a given year also gave in the next year (note I need the count of unique donors, not the count of gifts, which may duplicate). Thanks to some help received yesterday (h/t...

I have 6 dates in a medium dare format and am trying to count the number of dates in September by using month = 9 and then adding it to if they gave been paid “No. Was thinking of doing some code below =if(month($A$2:$A$7)=9”,1,0) However am getting a value error Anyone got any ideas