关闭

Formular for Excel, extract a list

这项目被授予 dangphap ,费用为$30 USD

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $250 USD
全部竞标
21
项目描述

I need help with excel, just one little thing. I have some columns and in some rows there is sometimes an amount. I need all tese amounts in one seperate list in a new file. I can show it exactly with picture descriptions: so in [url removed, login to view] you see that in one column is sometimes an amount and in [url removed, login to view] is it how it should look the new list, automatically from exc1.png. when the amount in exc1 is deleted it should also be deleted in ex2.

maybe it is possible to write automatically the date when the amount was added. and it should be possible to sort the new list, with animal, marke, date, notes.

I have a solution, but here it does not work when one marke has amounts at more then one animal, just one is listed. There should be listed all animals with all amounts. (at the example marke xxxx 7 should be listed the dog with 35 and the cat with 90). And the date should also be automatically the date of the day when the amount is entered, if it is possible. If not, not so important.

授予:

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online