# Posts by PY_

• ## Sort Table From Left To Right

Hello all,

I am trying to sort a range of cells A1:D3 in ascending order but while doing so, omit the blank cells and keep them at the end of the end of the range. Is something like this possible? I tried searching how to sort by ranges but all i have found is how to sort by columns or rows.

I attached an example of what i am trying to accomplish.

• ## Lookup X & Y And Return Z

Re: Lookup X &amp; Y And Return Z

Quote from AAE

=IF(NOT(ISBLANK(INDEX(\$A\$2:\$E\$8,MATCH(A15,\$A\$2:\$A\$8,0),MATCH(B15,\$A\$2:\$E\$2,0)))),INDEX(\$A\$2:\$E\$8,MATCH(A15,\$A\$2:\$A\$8,0),MATCH(B15,\$A\$2:\$E\$2,0)),"N/A")
This version will test for the a blank in the matching cell and return N/A. You might actually have a value that is zero and will not want to return N/A in such a case.

Thank you sir. I will look into which way works best for me.

• ## Copy Rows And Paste Into Columns

Re: Copy Rows And Paste Into Columns

Quote from Yard

Copy, Paste Special, Transpose

Thank you again good sir. You have helped me twice in a row and saved me lots of time.

• ## Copy Rows And Paste Into Columns

I am trying to save me a lot of copy and pasting. I have cells A1:A100+ with customer names listed out. I am trying to create a chart on a different page but on this particular chart, i need those customer names at the top of the columns going across the page instead of the rows. Is there an easy way to do this?

• ## Lookup X & Y And Return Z

Re: Lookup X &amp; Y And Return Z

Well, i was searching and searching last night for the answer and just gave up and decided to post my question. After posting, i found a similar formula not 5 minutes later.

• ## Lookup X & Y And Return Z

Re: Lookup X &amp; Y And Return Z

Quote from Yard

=INDEX(\$A\$2:\$E\$8,MATCH(A15,\$A\$2:\$A\$8,0),MATCH(B15,\$A\$2:\$E\$2,0))

Thank you. I guess i was on the right path after all.

• ## Lookup X & Y And Return Z

Greetings all,

I am trying to set-up a formula that will look up two different values of a grid (x & y) and the result will be the intersection of the two values (z). If there is not a value at the intersecting cell i will have it display "n/a". I have attached an example of what i am trying to do but i have no idea how to set up the formula.

I forgot to mention that the index or chart above remains constant but the lookups do change.

I believe i may have figured it out. Here is what i came up with for cell C19. Should i have done anything different?

=INDEX(\$A\$2:\$E\$8,MATCH(A19,\$A\$2:\$A\$8,0),MATCH(B19,\$A\$2:\$E\$2,0))

.

• ## Lookup Last Cell Containing X And Return Y

Re: Lookup Last Cell Containg &quot;x&quot; And Return &quot;y&quot;

Quote from tobeychris

Click on edit in your first post, then click go advanced, and you should see your misspelled title.

Thank you!

• ## Lookup Last Cell Containing X And Return Y

Re: Lookup Last Cell Containg &quot;x&quot; And Return &quot;y&quot;

Quote from RichardSchollar

Here's an option using your example:

=LOOKUP(2,1/(INDEX(\$B\$3:\$G\$6,MATCH(A10,\$A\$3:\$A\$6,0),0)="Yes"),\$B\$2:\$G\$2)

Richard

Thank you Richard, that works great. I tried daniel.c's code but it kept returning "0" as the result.

• ## Lookup Last Cell Containing X And Return Y

I understand how to set up a normal VLOOKUP, but I am not sure how to do the following: I am trying to set up a sheet that will find the last cell of a row containing "yes" and display the value of the cell at the top of that particular "yes" column. Maybe VLOOKUP is not the answer? I have attached an example of what i am trying to do.

• ## Hyperlink List Of All Files In Folder

Re: Hyperlink List Of All Files In Folder

Well i figured out how to create hyper links. What im trying to do is create a custom menu of a few specific hyper links and then share that custom menu with other users on the same network.

• ## Hyperlink List Of All Files In Folder

Re: Create Custom Drop Down Menu

Well I figured out how to create a custom tool bar that has a drop down list of files that i want to link to. I set up all the links to each of them and now i just drop the menu down, pick the file i want, and it opens it. But, i can not figure out how i can load this tool bar on another machine without going through that whole process on each machine i want it on.

• ## Hyperlink List Of All Files In Folder

Re: Create Custom Drop Down Menu

The list would be hard coded paths. They never change and if they did, i would update the drop down list.

• ## Hyperlink List Of All Files In Folder

Re: Create Custom Drop Down Menu

• ## Hyperlink List Of All Files In Folder

What I want to do is create a menu with hyper links to all of the excel files we use quite often here at work.

I have already done this by just creating a sheet with a list of hyper links on it but would like to put it in a drop down menu instead if its possible.

• ## Automatically Copy Cell By Selecting It

Re: Automatically Copy Cell By Selecting It

Thanks so much for the help. although, i ran into a "too many line continuations" error.

.

• ## Automatically Copy Cell By Selecting It

Re: Automatically Copy Cell By Selecting It

I did what you said about the checking the “Microsoft Forms 2.0 Object Library” option and it now works. Thank you again sir.

What would i add/change on your code so that i can have the option of selecting between two different cells and copying the text of the individual cells?

I want to copy A3, paste it, then go back and copy B3 and past it. I need to set this up for multiple cells but once i get an idea of how to do more than one, i can just apply the pattern to multiple cells.

• ## Automatically Copy Cell By Selecting It

Re: Automatically Copy Cell By Selecting It

Thank you Bill for the corrected code. I tried to use it on a sample sheet but i get an error highlighting " MyDataObj As New DataObject".

I also attached an example of a book using the code i posted earlier. It is still copying the text for me. Any idea why it works on this one particular sheet?

.

• ## Automatically Copy Cell By Selecting It

Re: Automatically Copy Cell By Selecting It

I see what your saying. I just created a new sheet here at home and it clears it. I will look at my other sheet when i get to work tomorrow and try to figure out what its doing different.

• ## Automatically Copy Cell By Selecting It

Re: Automatically Copy Cell By Selecting It

Maybe i am confused about the clipboard question but if your referring to the windows clipboard, No. I click in a cell, window pops up, hit "OK", then i can go to MS word or whatever other program, paste, and the text that was in that cell is pasted.

BUT, i am currently doing it on a cell that only has text, it does NOT have a formula in it. Maybe thats the problem.