Hey all just need some help, is there a way to search for matching date (cell G2) and output the only one with text in it (column C that also matches date in column A)
there will only ever be 1 answer under each date in column C.
Take a look at this hopefully makes more sense.
https://docs.google.com/spreadsheets...it?usp=sharing
Thanks
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi thanks for the reply, unfortunately that did not work it did not return a result.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I added a google sheets link what is where I'm trying to do it from, I'm away from home till Monday now so won't be able to add a different one till then sorry.
Anyone able to help with this? It's done with Google sheets, column a-c has the data, in column A is a list of dates, and column c will only ever have 1 entry under that date all I want to do is type in a date and it finds that 1 entry in column C and outputs it to a set cell, can anyone help, there is a google link and the top showing what it is I want to do, G2 shows the date I search for and G4 shows the result I require.
Last edited by Ditch1983; 05-28-2018 at 11:35 AM.
An Excel array entered formula that would do this is: =INDEX(C2:C28,MATCH(1,(A2:A28=G2)*(C2:C28<>""),0))
I believe that in Google sheets this would be accomplished by wrapping the INDEX function with an ARRAYFORMULA function.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks