Can someone please advise how to proceed?

I have a data base including 3 columns and 22000 rows. In the first column I manually add value=1 for which cells in the second column that is critical and leave the rest of the cells empty.

In another sheet, I need to summarize this data base for another purpose. So only the cells(in the second column) with value 1 is important for me.

If i use “If” formula combined with v lookup, something like +IF(MATRIX!A:A=1,V LOOKUP(MATRIX!B:B, MATRIX!B:E,1,0),) it will still give me the empty cells as well and I will have another file with 22000 rows while I only need the critical ones.

Thoughts?

Thanks

Max

By: MaxH

]]>So i have to copy and paste around 800 rows from one sheet into a table in another sheet. I copied the cells and clicked on the first row on the table in the second sheet. Now keep in mind that the copied rows have less columns than the table destination. After clicking on the first row of table destination and click “Insert Copied Cells”, a box pops up saying “Shift rows down.” or “Shift rows right”. I need the entire rows to be shifted down but when I click “shift rows down”, ONLY the same number of columns as the copied cells are shifted down. So all the columns to the right remain unchanged. When my co worker completed this step, the enitre row was shifted down. Please anything would help as I have tried everything!

By: Sara White

]]>“aaa” on one line; a blank line; and then on the next line “bbb”.

How can I find all instances of this combination in a Worksheet containing thousands of rows?

Thanks in advance.

TC

By: TC

]]>I have a spreadsheet that looks something like this:

A1 | B1 | C1 |

Player | Price | Points |

Matthew | 9 | 4 |

Ellen | 12 | 7 |

Toby | 16 | 8 |

Joshua | 11 | 5 |

Marika | 10 | 5 |

Liam | 8 | 3 |

Carter | 9 | 5 |

Julia | 15 | 9 |

Now, the idea would be to select 3 Players with a sum total Price of no more than, say, 33, that would give me the most possible Points.

Is this possible with excel?

Sorry, I am inexperienced with the different formulas and Excel in general, and couldn’t find any related topics!

Thank-you for your assistance!

By: Tyrell

]]>By: San

]]>For this, Column D=Online Posted Date; Column E=Expected Index Date; Column F=Due in X Days/Overdue by X days

I was able to calculate the expected due date of 45 business days from the publication date with:

=WORKDAY(D7,45)

But when I try to calculate how many business days are left before the expected index date, I can’t figure out how to add WORKDAY to the formula:

=E7-TODAY()

And I can’t figure out how to calculate how many business days late it is, which would be “Today” minus the expected index using the WORKDAY function.

By: BB

]]>In column A I have a title, and in columns B, C, D, I have a numerical value.

But in column A, I have duplicate titles, separated by (currently font color but in the example below, the underline indicates a new data set) and I want the numerical values in BCD, to move specificall to columns EFG next to B, C, D, but only if the title in column A is the same. And for the third data set, if its a duplicate title, i’d like to move the data from BCD into HIJ, leaving a gap if there no duplicate

EX: IF what I currently have is this

A B C D E F G

A 1 2 3

B 2 4 5

C 3 7 4

A 2 5 8

C 4 9 5

D 3 2 1

A 5 9 4

B 3 5 3

D 5 3 8

E 4 3 7

I want it to be:

A B C D E F G H I J

A 1 2 3 2 5 8 5 9 4

B 2 4 5 3 5 3

C 3 7 4 4 9 5

D 3 2 1 5 3 8

E 4 3 7

I would like the first Data set to stay in columns BCD and the second to move to EFG and the third data set moved to HIJ.

Does this make sense? I don’t want to copy and paste because it would take forever. Any short cuts?

By: Vinny

]]>

Is this possible by using a formular and not VBA code?

By: Ronel

]]>Please help me to get the Excel formula used in excel 2007.

I have today() date function in my excel,but i want to use some formula where it will stay on today() date and it should not cross the date after the month end.

Kindly help me with formula.

By: Shasi Ranjan

]]>as i am working as a data anayst. there is a excel report where i have to copy paste the whole data from diffrance 5 files.. every time i just have to do ctrl+c and ctrl+v for that so is there is any shortcut for the copy paste of whole data

By: anmol

]]>