[EXCEL/Google Sheets] Conditional formatting, filtering.

Closed job

extension 2 deals

Freelancer with good TS skills

Proposed by freelancer

11

84d

We're looking for a freelancer with good TS skills for a long-term collab. Must have: - Strong TypeScript skills - Knowledge of React and it's ecosystem (TanStack-Query, react-hook-form, Storybook) - Knowledge of Tailwind - Knowledge of client-server protocols (HTTP, GraphQL) - Experience in building maintainable and scalable systems, design systems, and writing tests Nice to have: - Web3 skills - Basic experience in building browser extensions - Knowledge of WebSockets

MKING

Employer

5 deals

Job category:

Software

Expected budget:

Negotiable

Preferable skills:

excel

Published: on 2024-03-27

Finished

Job description

We have a database in Google Sheet format,

1) we want the function to check and select automatically:

If the value for the row in column X in sheet no.1 is the same as the value for the row in column X in sheet no.2, it marks the whole row in sheet no.1 and sheet no.2 with green color.

2) Set filtering - Rows marked in red did not display in sheet no.1,

rows highlighted in red from sheet #1 were shown in sheet #3.

3) For the functions and filtering given above, (disregard the rows in red) search for duplicates for column X in sheet number 1 and the repeating function show in sheet number 4.