Peruttu

Simple data filtering project- Need IMMEDIATELY with more to follow

Contractor will be given 1 Excel csv file with 4 columns of data (all numbers only). Sheet can be arbitrarily large, not fixed size.

Headings and sample row of sheet illustrated below-

L, D, V

43.23, 2.31, -0.5

Data will be filtered by me on on any column(s) using excel standard "filter"options.

Need formulas that will output, the following, once standard Excel filters are applied (ok, if there is output before filter is applied as long as it makes sense)

- X rows above and below each filtered result row ( X will be an input value through some cell you designate) in to another Excel Sheet

EXAMPLE 1

So for example if after filter is applied to a 20 row sheet, X=3 and the results are

row 7

Then your Excel formulas etc must print out full data for (in a anew sheet)

row 4

row 5

row 6

row 7 -- (3 rows above + 3 rows below)

row 8

row 9

row 10

where "row 4", etc = full row data like: 12.66, 2.55, -3243 etc

Resulting filtered rows may have over lap, so

EXAMPLE 2:

if after filter is applied to a 20 row sheet, X=3 and the results are

row 2

row 7

row 9

Then your Excel formulas etc must print out full data for (in a new sheet)

row 1

row 2 -- (only 1 row above so only print that + 3 below)

row 3

row 4

row 5

--------------------blank row

row 4

row 5

row 6

row 7 -- (3 above and 3 below)

row 8

row 9

row 10

--------------------blank row

row 6

row 7

row 8

row 9 -- (3 above and 3 below)

row 10

row 11

row 12

--------------------blank row

-PLS ASK MORE QUESTIONS IF UNCLEAR THIS IS AN IMMEDIATE REQUIREMENT WITH MORE TO FOLLOW-

Taidot: Excel, Visual Basic

Näytä lisää: data filtering, data filter, sample data input, project input output, sample visual basic excel, 2013 excel visual basic, simple makes, file filter excel, excel 2013 visual, lap, excel data filtering, excel print sheet, filtering excel, filtering results, visual basic excel 2013, excel filtering, filtering data excel, sheet data input sample, excel 2013 visual basic, project need immediately, bid project data need list top universities, data structures simple project, print excel, simple project data entry, follow excel

About the Employer:
( 0 reviews ) United States

Projektin tunnus: #4229690

11 freelanceria on tarjonnut keskimäärin 63 $ tähän työhön

bharanisrihari

Hello, Excel VBA expert here. Consider it done. Please check PM for details. Thanks!

60 $ USD 1 päivässä
(66 arvostelua)
6.4
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to Lisää

50 $ USD 1 päivässä
(47 arvostelua)
5.6
deepbluetech

I am an Excel expert and can take on the job. Let me know.

100 $ USD 1 päivässä
(88 arvostelua)
5.3
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

99 $ USD 1 päivässä
(14 arvostelua)
5.3
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== Lisää

30 $ USD 1 päivässä
(14 arvostelua)
4.4
bubu77

Hi, Excel expert having 8+ yrs of IT experience. Please see your PM for more details.

50 $ USD 2 päivässä
(1 arvostelu)
2.0
sthakral

Hi, Your macro is ready, pls see pmb Sandeep

30 $ USD 1 päivässä
(1 arvostelu)
1.9
syamu84

I can finish this task in short time, with the best quality.

40 $ USD 7 päivässä
(0 arvostelua)
0.0
hsalman2010

Ready to start the work. Plz check PM.

50 $ USD 7 päivässä
(1 arvostelu)
0.0
sahmed1985

i am new user of freelancer please give me this project

30 $ USD 2 päivässä
(0 arvostelua)
0.0
shaeed019208789

Hello, I think I can help. Send your project details. Thanks

150 $ USD 7 päivässä
(0 arvostelua)
0.0