Re: Sorting Formula
Thanks for the response...having some issues with the formula...if the ranking values are not sorted, you will get some N/A values, which is an issue.
Any other solutions?
Re: Sorting Formula
Thanks for the response...having some issues with the formula...if the ranking values are not sorted, you will get some N/A values, which is an issue.
Any other solutions?
Re: Sorting Formula
Thanks for the response! I've created a sample of my desired results below the original sample set.
I have attached an example sheet.
I have names in column A and their ranks across multiple columns/categories. The ranks are also color coded.
I would like to sort/rank each column and have the name appear in the column instead of the rank using a formula. I would like the formula to be dynamic as well.
Any help or hints are appreciated.
Re: Copy and paste row if cell value within date range
Thanks for your response!
The range number of rows will not always be the same.
Hello all.
Haven't been able to find an answer for what I'm trying to accomplish. I have data in a worksheet (columns A to BA). The data is sorted oldest to newest based on the date in column L.
I would like to be able to go through the data, copy and paste rows into a new worksheet if the date in column L falls into a particular range.
I appreciate any suggestions.
I have a row that I am using as a base (L2:Q2). I am trying to compare that values in the rows below (L3:Q8). I realize it would be easy to do conditional formatting for this one range, but I have a much bigger sheet and it would result in me doing conditional formatting entries over 100 times.
I want to look at each cell in the range L3:Q8 and compare it to the cell that is in the came column in range L2:q2. If it is less than, color it red, if its not do nothing.
Any help would be appreciated.
Re: Create Decile Rankings
It appears to have worked! BINGO! Thanks for your quick response!
This issue is due to the limitations of the nested if formula. I have range of cells that contains percentile rankings 1-100. I am trying to figure out how to convert the cells that contain values 1-10 to a 1, cell values 11-20 to a 2 and so on. Any help would be appreciated.
Re: Lookup Value And Return An Offset Value
Dave,
Thanks for your prompt reply. It doesn't appear that "cat" can be a cell reference (A32). Is that true?
Greetings Everyone!
I am referencing a value in column A of Sheet 1. I am looking for that value in column B of Sheet 2 and would like to return the value of the cell that is 1 row below and 4 columns to the right (column F). I need to do this multiple times.
Can I use a VLOOKUP/OFFSET combo or Index/Match?
I am writing the formula in column H of sheet 1.
Any help is greatly appreciated.
Re: Mail Chart & Range In E-mail Body
If you wouldn't mind me asking, how did you go about emailing the cells?
Good Evening Everyone!
I have read the extensive posts on automating PDF printing and still can't seem to figure out my problem.
I am attempting to print a range of an excel sheet as a PDF. The PDF would end up on my desktop. I recorded a macro to do most of the work. My problem is the filename. How do I tell the Macro to save it as a certain file name everytime the procedure runs. I have the full version of Adobe
Here is my existing code below.
Re: Copy Range Of Cells Into Email
I figured it out...
Here's the way I did it.
Greetings All!
I am trying to get Msg to equal a range of cells in Sheet 2 (B1: G105) so that those cells are pasted into the email as text.
The code below works, it just needs some modifications for Msg.
Any help is appreciated as I have searched a ton of threads and other websites as well.
Re: Lookup Value Inlist And Return A Value If Its Found, Return Another If Not
Sorry about the code tags.
Your suggestion worked perfectly. I appreciate you helping me out so quickly.
I am trying to Lookup a country to see if it is classified as a "Developed Country".
My formula would be in cell AA4. I want to see if the country in cell B4 is on a list of developed country's on another worksheet. IF the country is found on that list cell AA4 displays Developed. If the country is not on the list, cell AA4 displays Emerging.
I have tried an IF statement using the Match function and it does not work. Any suggestions?
=IF(MATCH(B4,'Developed Country List'!$A$2:$A$37,0), "Developed", "Emerging")
Re: Comparing Column Data
What a silly mistake! I just need to close the space.
I am trying to add a third if statement to my existing code looking to see if a cell in a column is blank and the corresponding cell in another column contains a number that is greater than or equal to 1. I can't figure out how to write that part of my IF statement. Any help is greatly appreciated.
Re: Copy Non-Contiguous Range & Paste To Last Used Row
Gotcha! Thanks!
Re: Copy Non-Contiguous Range & Paste To Last Used Row
What is the part of the code that is making it go to the first empty column? I would like to just be able to specify a starting cell location and have it paste there. Thanks for helping a newbie with his learning curve!