Cac anh, chi cho em hoi doi dieu ve Excel: Trong mot file du lieu, em da tao xong 2 sheet chi tiet, nhung yeu cau dat ra la phai cong cac sheet chi tiet lai thanh mot sheet tong hop chung (cong viec cua em doi hoi the). Em da loay hoay mai nhung khong co cach nao.
Vay cac anh chi danh chut thoi gian huong dan em cach xu ly nhe!
Kinh mong nhan duoc su ho tro cua cac anh chi. Chan thanh cam on!
Pham Ngoc Anh
Hoi am:
Ban chua noi ro "cong chi tiet" la ban muon cong dang nao. Toi tra loi ban cong viec don gian nhat (theo cach hieu cau hoi cua ban) la: Tai mot o dia chi cua sheet 3 (sheet duoc goi la sheet tong hop), o nay (dang number) nhan ket qua cong du lieu (dang number) tai 1 o dia chi cua sheet 1 voi du lieu (dang number) tai 1 o dia chi cua sheet 2, ta lam nhu sau:
Tai o dia chi cua sheet 3, go =
quay lai sheet 1, nhap chuot vao o dia chi can tong hop roi go +
quay lai sheet 2, nhap chuot vao o dia chi can tong hop roi go Enter
Gia tri hien tai o dia chi cua sheet 3 luc nay la gia tri tong cua 2 gia tri tai 2 o dia chi cua sheet 1 va sheet 2. Tu luc nay gia tri tai cac o dia chi cua sheet 1 va sheet 2 neu co thay doi se dan toi gia tri cua o dia chi cua sheet 3 thay doi theo nhung luon bang tong cua 2 o do.
Hung
