Hello
I am using the address formula to give me the cell reference, but the output which i am getting is the row and the column address as text.
eg
=(ADDRESS(MATCH(MIN(N2:N288),N2:N288,0)+1,10,4,))
The output which it displays is "J50" in the cell containing the formula, but i want to...
We maintain a order-book (bulk order) in google spreadsheet which is shared by 4 different persons, and involves a lot of followup and entering of data by all the persons. can the data be updated on a real-time basis on Google calender as events so as to manage better.
Thanks