yogi_Look At Entry In Each Row Of Column D If The Entry Has Not Occured In Rows Above Mark 1 Otherwise Leave Blank

Google Spreadsheet   Post  #2114

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-27-2017

question by Brad O.:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/QCPcSjXiJVQ;context-place=forum/docs
Array Formula for a variable range
I've been trying hard to get an array formula to work for my specific issue and I need some help with it.

I need an array formula that will auto expand into new rows.  The formula needs to search all previous rows only for a value from the new row.  If it's present, insert a 1 into the cell, and if not, do nothing.  Basically, I'm just checking if this is the first time the value appears in the sheet and if so, mark it with a 1.  Future occurrences of the same value would be ignored.

Here's an example of the formula that works, if I manually copy it into each row: 

=IF(countif($D$2:D9,D9)=1,1,"")

I've tried every way I could think of to convert this to a working Array formula that would auto expand into all future rows but I cannot seem to find the right way to do it.

Any suggestions on how to make this happen, either with Array Formula or other ideas would be greatly appreciated!

yogi_Compute Number Of Entries During Each Shift Shift Begin And Shift End Times Are Not On Same Day-02

Google Spreadsheet   Post  #2113

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-24-2017

question by Holiday Claims:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/wSuFOUUGqTg;context-place=forum/docs
Number of entries added between two different time-stamps, Not on same day

We start our shift at 11pm in the evening and finish 7am the next morning. What formula can I use to see how many entries are made during each shift?

18/01/2017 11:55:40	Day 1	Shift Starts 11pm 18/01/2017 Finishes 7am 19/01/2017
19/01/2017 06:55:40
19/01/2017 23:45:41	Day 2	Shift Starts 11pm 19/01/2017 Finishes 7am 20/01/2018
20/01/2017 00:00:07
20/01/2017 00:03:18	Day 3	Shift Starts 11pm 20/01/2017 Finishes 7am 21/01/2019
21/01/2017 00:03:18

yogi_Compute Number Of Entries During Each Shift Shift Begin And Shift End Times Are Not On Same Day-01

Google Spreadsheet   Post  #2112

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-22-2017

question by Holiday Claims:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/wSuFOUUGqTg;context-place=forum/docs
Number of entries added between two different time-stamps, Not on same day

We start our shift at 11pm in the evening and finish 7am the next morning. What formula can I use to see how many entries are made during each shift?

18/01/2017 11:55:40	Day 1	Shift Starts 11pm 18/01/2017 Finishes 7am 19/01/2017
19/01/2017 06:55:40
19/01/2017 23:45:41	Day 2	Shift Starts 11pm 19/01/2017 Finishes 7am 20/01/2018
20/01/2017 00:00:07
20/01/2017 00:03:18	Day 3	Shift Starts 11pm 20/01/2017 Finishes 7am 21/01/2019
21/01/2017 00:03:18

yogi_From 'Form Responses Sheet' Compute Monthly Totals By Items Built

Google Spreadsheet   Post  #2111

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-21-2017

question by jrh456:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/aJXAAwNHyVI;context-place=mydiscussions

Need SUMIF to work for a multisheet equation

 Please assist me as I have tried to follow along but these equations make no sense and I am very lost I have a form that will be filled out by employees and the responses feed into a response sheet, I then need monthly totals from that response sheet I know I am supposed to use a SUMIF formula but it does not seem to work at all. In other words if the timestamp is January then it should total in my january total;s 

yogi_Group Total From Table Of Entities And their Corresponding Amounts

Google Spreadsheet   Post  #2110

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2017

question by tiledude:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/qNW8dJag7PM;context-place=forum/docs
Arrays and adding columns of data

Hello,

This formula works fine and is giving the correct prices based on AW. 

I am trying to add the data from AW.

basically trying to add another column of data.

=QUERY('Copy of 01-FBA'!4:1000, "select SUM(R) GROUP BY AW label SUM(R) 'R'")

thanks for any help :)

R	AW
14.99	data from AW
439.82	data from AW
1169.52	data from AW
299.86	data from AW
194.91	data from AW
14.99	data from AW
169.9	data from AW
209.9	data from AW
49.98	data from AW
39.98	data from AW
304.83	data from AW
174.93	data from AW
144.93	data from AW
99.96	data from AW

yogi_Reverse Entries In Sheet Named Data Horizontally (except for entries in first column)

Google Spreadsheet   Post  #2109

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2017

question by PY_:

https://productforums.google.com/forum/#!topic/docs/CZjRNAgMyUg;context-place=mydiscussions
Reverse data horizontally
I have a massive spreadsheet of data that can grow horizontally and vertically. What I'm trying to figure out how to do is duplicare that data on another sheet only in reverse order horizontally using formulas or a script starting at column B. Is there a formula or script I can use to accomplish this? Keep in mind that the column and row numbers change so the formula/script needs to be able to change with it.

yogi_What Words Occur Most Often In Range A:A And Their Corresponding Frequency

Google Spreadsheet   Post  #2108

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2017

question by hlopez_:

https://productforums.google.com/forum/#!topic/docs/T2fqkh1OHHU;context-place=forum/docs
Count every word in column and display word and frequency

I have a column of 4000 entries. Each entry has a sentence. I would like to know what words occur most often in the A1:A range and their corresponding frequency