Excel Pivot/ Macro

종료 등록 시간: 2년 전 착불
종료 착불

i need help in some raw data i have on excel that includes huge data amount of attendance sheet and i want to make a pivot table in order to filter out people who have recorded absence after the last day they attended.

i want to check each employee when was the last time they came to work... and then check if they were absent after their last time they came to work, if they were, put their names on a list and clean all their data from the big all data sheet. so for example i shahd.. the last time i went to work is 1st of january, but then i was absent after that, day.. if i was absent , then i want my data to be cleaned out of the all data ... and have my name on a seperate [login to view URL] shahd's record for example is reported, absent reported absent absent .... then it will become reported absent reported Only... so the last 2 are removed because i was absent after the last time i reported

엑셀 비쥬얼 베이직 데이터 처리 앱을 위한 비주얼 베이직 Excel Macros

프로젝트 ID: #32775253

프로젝트 소개

33 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 2년 전

이 일자리에 대한 프리랜서 33 명의 평균 입찰가: $30

rohitagarberg

hi there, i will clean the sheet of all that persons who were absent after the last day they have attended, will do right now, thanks...........................

$20 USD (1일 이내)
(426 리뷰)
6.7
mf12343

Hello there, send me the file and ill do the task even before awarding the project and will show you results

$15 USD (1일 이내)
(7 리뷰)
4.4
Gkiprop

Dear employer, I hold master's in statistics and continuing with Ph.D. in applied statistics making me suitable for this job. Am an experienced statistic writer for three years. Besides I am skilled; R programmers sps 기타

$20 USD (7일 이내)
(20 리뷰)
4.1
MamukaB

Good Day I'm doing reports using excel VBA from big data bases Using filtering, sorting etc I think I can do the project within less then 2 day, but need some more detailed clarifications from you and see the data I h 기타

$30 USD (2일 이내)
(12 리뷰)
4.2
sonuraj2309

Dear Hiring Manager I would like to let you know that i am very hard working and dedicated person , I only take payments when my clients smiles on my output, i ll do my work with full honestly. As i am new freelance 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
Philostructure14

"Hi Shahd I am Experted in Excel I have free time I can help you with that Please give me more information When do you want the job done? Thanks "

$30 USD (7일 이내)
(0 리뷰)
0.0
gracew20

Hello, I am Grace ,your data analyst professional in the following areas, with 4 years experience ≥macros ≥VBA ≥pivot tables ,power query,charts and dashboards with slicers and timeline ≥Automation of sheets with for 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
Nanaavl

I am an expert creating automate excel tools, is my every day work and i am really fast working with it

$10 USD (1일 이내)
(0 리뷰)
0.0
mohaz14

I am a data analyst, I have an excellent understanding and proficiency of platforms for effective data analyses, including SQL, BigQuery, Google Data Studio, Google Sheets, Excel, PowerBI, Tableau, Python, pandas, Matp 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
SergioyAndrea

Ya está hecho... Te propondré la mejor solución automática para lo que necesitas... La prueba está en que, si eres capaz de pensar lo que necesitas, entonces seguro ya lo sé hacer. ¿El Idioma?, No te preocupes, atende 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
zulhilmiii

Hello there, I'd love to help you with your project. I understand that you need help to make a pivot table to filter out people who were absent after the last day they attended. I am a great fit because I am well-ver 기타

$10 USD (1일 이내)
(0 리뷰)
0.0
jacquelyc

This is a very simple project. If the client can brief me more details of what he really needs, I have no problem to complete the task. With my 20 years of designing the systems and 30 years of programming with almost 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
iqrashameem41

Experience with advanced excel and VBA, creating executive dashboard, synthesizing raw data, and R programming

$20 USD (7일 이내)
(0 리뷰)
0.0
souravvsinghal

Hi, Request you to check and go through my portfolio to check out some of the recent project submissions related to your project. The project could be delivered as per your exact demand. Looking forward to discussi 기타

$20 USD (7일 이내)
(0 리뷰)
0.0
Elestadistico

I am qualified to do it, I have a lot of experience in Excel sheet automation, and if I cannot do it with Excel formulas or functions, or if it is not recommended, due to the amount of formulas that the spreadsheet wou 기타

$25 USD (7일 이내)
(0 리뷰)
0.0
Johnnymbasu

Hi there, I see you're lookig for an excel expert who could do pivot tables and summarise your needs accordingly for your ongoing project. So, I'll be perfect for this job as I've been providing my services in this fi 기타

$10 USD (2일 이내)
(0 리뷰)
0.0
hafizhan

Hello, I can help you to make macros on excel that can run automatically to find and move the data.

$20 USD (7일 이내)
(0 리뷰)
0.0
Waseem1511976

I am the excel expert and I have been working on it since last 20 years. I will be really happy to complete the job, because I can give you the result that you can track your employees or whatever your requirements. W 기타

$10 USD (1일 이내)
(0 리뷰)
0.0
computerscienc11

I read your project details very carefully and i have 3 years experience in this work so i can do it very easily. i can do it for free because i need for reviews.

$11 USD (2일 이내)
(0 리뷰)
0.0