Get instant live Excel expert help with ROW Functions

Need help with a excel data cell contains row number need them organized based on the row number in the tex

Hi Just had some one try and sort a foumal out for me i have data in the cells the data contains a row number i want the cell data to reloacted as per the row data cell row number

I need to put headings on the top of each column and don't want them to be sorted when I sort the rest of the list. How do I stop the top row from sorting when I want to sort the lists 4 columns in different ways?

I would like the UNIQUE formula to also select another row

We need a conditional formula to move names from one worksheet to the next if they have a passing score on that sheet. Today we are doing that using this formula: =IF('Resume Screening'!$AK3>='Passing Scores'!$B$2,'Resume Screening'!A3,"") We put this in the cell on the next worksheet where we want to pull in the applicants unique identifier. This part is working, however if we have a candidate who does not pass then we are left with a blank row. This is something that could be manually filtered out every time you look at that sheet, but this is not ideal and we would prefer to roll all of the rows with values up to the top of the sheet.

I have a large amount of data that I need to sort based on descending numerical order (the values are in column A), and the data is in table format—most of the data is text, and Excel won't sort the data all together because the cells are of a different size. I need the data that is in each row to stay together, because it is specific to that row—so I'm having a bit of trouble with this spreadsheet right now, and I don't know how to cleanly get the data sorted without having to manually sort it.

I'm trying to sort data by descending numerical value while keeping each row attached to their assigned numbers in Column A after the sort completes.

I need a vba macro created. I need to create a dynamic array that stores the values of each cell in row N...I need it to assign values based on the value of the cell...if after 11am and before 2pm then value=lunch..if after 2pm and before 5pm then value=afternoon, if after 5 and before 8pm then dinner, past 8pm value =latenight. I need these values to be transposed onto row w. I need it to be run as a macro and the values must be stored in an array then transposed. The transposed values will either be lunch, afternoon, dinner, late night with their values being based off of the values of the cells in row N

I would like to copy a row from one sheet to another sheet on the next empty row when the original sheet displays certain text.

when i am creating a Sumif it is working perfectly however the sum is not picking up this one row of data that is the same as all the rows in the spreadsheet. Is there a reason for why it isnt picking up this data.