-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
duck
-
M
Grouping certain value by colomn
Dear Forum Need help please. I have entries raw data that not in order like this. Entry No 1, Car, Duck, Cabbage Entry No 2, Bird, Banana Entry No 3, Plane, Bird Entry No 4, Bike, Pea Entry No 5, Pear Entry No 6, Car, Duck, Banana Entry No 7, Duck, Bike I want all entries will grouping...- manggo
- Thread
- bird car duck entry ordering by group
- Replies: 11
- Forum: Excel Questions
-
N
Vlookup with either two lookup value/Column
<colgroup><col><col></colgroup><tbody> Column 1 Column 2 Chicken - Duck - Dog - Butterfly Snake - Pig - Ant </tbody> <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Table Chicken 10 Duck 20 Dog 30 Snake 40 Bear...- nurulnabihahabdullah
- Thread
- ant column dog duck pig
- Replies: 9
- Forum: Excel Questions
-
P
Look up row from sheet1 and return average of cells from row.
Hi, I'm looking for help on a formula to look up a row based on a cell value and return the average of adjacent cells from that row. eg: look up Duck and return the average of cells. <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> Duck 2 1 4 1 3 4...- pgfindlay
- Thread
- average cells duck return row
- Replies: 4
- Forum: Excel Questions
-
G
Compile data
Hi, Im having a problem where I want to compile data from several rows into 1 single row. The data in this case is time and attendance data to upload into a payroll software. There are 9 different columns as follows: Code Code nr Code name Employee ID Employee name Number (hours/days) Type...- ghederberg
- Thread
- code days donald duck vacation
- Replies: 3
- Forum: Excel Questions
