Job Recruitment Website - Property management - Excel forms, such as the electricity payment records of a hotel, want to find the corresponding property and its latest payment date from a pile of data.
Excel forms, such as the electricity payment records of a hotel, want to find the corresponding property and its latest payment date from a pile of data.
= index (b 1: b2000，max(if(a 1:a 2000 = " xx property "，ROW(A 1:A2000)，0))
Ctrl+shirt+enter three-key input, xx property changes its name or references the cell.
- Related articles
- Is it illegal for owners to pay property fees?
- How about working in Lanzhou Xicheng Pharmaceutical Company?
- Is Tangzi Street suitable for living? Is it clean?
- What is the future sales service hotline of Xi An Fengdong I?
- How about the surrounding facilities of Ganzhou boutique building materials decoration square community?
- How about the east bank of the Pearl River in Huizhou? Is the house worth buying?
- Xi, which phase of Anjianglin New City is the best?
- Which residential areas in Wu Hanyou are equipped with ground source heat pumps? Want to know if my community is suitable?
- Mid-Autumn Festival is suitable for company copywriting.
- Where is the address of Huizhou Jingdi Purple Garden?