yogi_For Words In Column C Compute Row By Row Category Based On Specs In 'Words to look for'

Google Spreadsheet   Post  #2566

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-03-2019

question by: DanielF:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/YFvMMiVY-1g;context-place=mydiscussions
Finding one word out of a range of words in a text cell.

Hello guys,

I am looking for a way to search for a range of words in a text cell and then give the given category of the word which was found (so 1.1,1.2 etc.). If no word is found in the text cells then nothing should be shown. The words I am looking for and the categories are shown in the attachments. These are just some examples and the categories are going to be large (100+).

Thanks in advance!

Daniel

Table.jpg

7 KB

yogi_Pull Data For Only First Instance Of Entities In Column E Of Sheet 'Upload.OP'

Google Spreadsheet   Post  #2565

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-03-2019

question by: DennBA:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/A3Q2FTvK0vc;context-place=forum/docs
How to who only one data of a kind (with filter)?

Hello,

can I only show one data of a kind and hide the other ones with the filter?

I made some screenshots, to explain it.

I want to hide the rows which are strikethrough in red. (Screenshot 1)

Which formula do I have to use in the filter? (Screenshot 2)

Thank you very much!

Dennis

Screenshot 1.png

270 KB

Screenshot 2.png

295 KB

yogi_Post Row By Row In Column A Letter From Row 1 That Corresponds To Column Where Last x Resides In The Row

Google Spreadsheet   Post  #2564

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-02-2019

question by: Benedek Bodnar:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/uig7YOiDA2I;context-place=mydiscussions
Aggregate function

Hi,
I want to upload a microsoft office excel sheet with an AGGREGATE function, but it does not work with google sheets.
I printscreened the issue. The formula I used is from another forum, and it worked in the microsoft excel.

What I want to see in A2 is the letter in row 1 that has the same coloumn as the last cell filled with and 'x' in row 2.
Thank you for the help.
Benedek

sample_.png

15 KB

yogi_For Values In Column A of 'Large' Lookup Values In Columns A:C of 'Small'

Google Spreadsheet   Post  #2563

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-02-2019

question by: Timothy Hanson:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/dQPfq7dK45E;context-place=mydiscussions
how to vlookup a smaller range in larger range to the end of the larger range

Hello,

I have a range on a sheet called "Large" of 40,000 rows and on a called sheet "Small" of 550 rows.  Both in column A

I can use Vlookup to search for all the matches of the large sheet in the smaller sheet

    =ArrayFormula(iferror(vlookup('Large'!A2:A, 'Small'!A$2:E, {1,3}, false)))

and this searches to the 40,000th row

But I need to go the other way I need to search 

    =ArrayFormula(iferror(vlookup('Small'!A2:A, 'Large'!A$2:E, {1,3}, false)))

and have it search through all 40,000 rows of "Large"

But this only searches to the 550th row which is the range height of "Small"

I need to do it this way because I need the posted back columns {1,3} of Large sheet not of Small sheet

I have searched but have found nothing to help with this

Thanks

Here is an example sheet

https://docs.google.com/spreadsheets/d/1i4UpD-9osVz7K8NAzAYM61_BAnwdXIsWodQrKaYi9n8/edit?usp=sharing

yogi_From DateWise Expense Table Compute Totals By Months Of The Year And Specified Categories

Google Spreadsheet   Post  #2562

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-01-2019

question by: Drake1996:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/meNrS7pFD6U;context-place=mydiscussions
Help with Sumif function
https://docs.google.com/spreadsheets/d/1_haeRz6b0QW3q2KjJx-t9-z2nRxYtJknvDTEggDs-9o/edit?usp=sharing

I would like to have sumif the date is in a month but I couldn't figure it out 

I also wanted to sum if driving but driving is only part of the text

feel free to edit the doc this is the copy I made for it

yogi_Pull Into Column E Sum Of Entititis from Matching Entries Of Column A In Tab1 Tab2 and Tab3

Google Spreadsheet   Post  #2561

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-01-2019

question by: Quinton Florence:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/zzIUHN2LIyc;context-place=forum/docs
SUMIF Across Multiple Tabs
Hey everyone, I'm simply trying to sum amounts across different tabs, if a column in each tab is equal to a cell. 

For example, if A2 in tab "December 2018" matches any entry in column C for tabs: "Tab1', "Tab2", and "Tab3", enter the sum in cell E2 in tab "December 2018". I hope this makes sense. Any help is greatly appreciated!

https://docs.google.com/spreadsheets/d/1BbCeyRDA7cG10-veCm2iiCDNtTSckdVFCBrZJqZYX5A/edit#gid=8543398

yogi_Conditionally Format Cells In One Column That Match Any Cell in The Other Column

Google Spreadsheet   Post  #2560

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-01-2019

question by: Ari R:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/DA2kzqnBsF4;context-place=mydiscussions
Google Sheets matching entries highlighted
I need all matches in Columns A & B to be highlighted in green and which don't match to be highlighted in Red.

https://docs.google.com/spreadsheets/d/1cTdBV-_9lhDCDBJXAtJs2oGkTtgK72RN8A8w7tEr34Y/edit?usp=sharing