Đã Đóng

Advice on Excel code

=IFERROR(INDEX(Data!B:B, SMALL(IF((OR(Data!AG:AG='Working Date'!$A$1,Data!AR:AR='Working Date'!$A$1)), MATCH(ROW(Data!CM:CM), ROW(Data!CM:CM)), ""),ROWS($A$1:A1))), "")

Anyone able to tell me why this how to build this "OR" function into an index and match function?

Kĩ năng: Excel

Xem nhiều hơn: excel excel code import spreadsheets, excel code creating xml files, separate street name address number excel code, how to use excel formulas, useful excel formulas, excel tips for beginners, excel tips and tricks 2019, excel tips and tricks 2018, excel tips and tricks pdf, excel formula, excel formula review, vba excel code install add ins, copy paste excel code, price excel code, refresh web service excel code, copy browser spreadsheet excel code, excel code paste cut cell csv, excel code bid, trados discount 100 match match, optimize excel code run faster

Về Bên Thuê:
( 3 nhận xét ) Mordialloc, Australia

ID dự án: #26876771

11 freelancer chào giá trung bình$13 cho công việc này

writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 hour

$15 AUD trong 1 ngày
(50 Nhận xét)
5.3
swarnali2017

Dear Employer, I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see Thêm

$20 AUD trong 1 ngày
(8 Nhận xét)
3.4
professional800

Greetings I have more than two decades of experience of using excel and teaching excel. i can explain you immediately. I would explain untill you become expert of it. Thanks

$10 AUD trong 1 ngày
(3 Nhận xét)
2.4
arunkumar9896

Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Arun

$20 AUD trong 1 ngày
(1 Nhận xét)
2.0
Emmyope93

Hi, Good day. I understand you need help with this Excel formula and I will like to assist you on this project. I am a young, intuitive, savvy and smart Business Consultant currently practicing in the Consulting Servi Thêm

$18 AUD trong 1 ngày
(2 Nhận xét)
2.1
rameshraja86

Hi, I have understood your requirement. I can develop or alter the calculation if you want to change it

$15 AUD trong 1 ngày
(2 Nhận xét)
0.6
ExcelAnything

Hi there! I have over 8 years experience in Array formulas. I can teach you basic to complex array formulas for 1 hour and clear all your doubts. I can assist you with the best possible effort with minimum charges. I h Thêm

$10 AUD trong 1 ngày
(1 Nhận xét)
0.0
ShakeelASESE

hy Sir I can help to fixing and find the error in formula now please end me an Excel sheet include this formula. thanks

$10 AUD trong 1 ngày
(0 Nhận xét)
0.0
yogeshkekadia

Good morning sir I read your project details. I complete your work in the given time please give me this project Thanks

$10 AUD trong 7 ngày
(0 Nhận xét)
0.0
Meeshal164

Let me introduce my self i am meeshal and i am working as a software developer since 2 years. I can resolve this issue.

$10 AUD trong 7 ngày
(0 Nhận xét)
0.0
maksimdevkid

Hello, I can answer for your question. I am excel expert. I can solve this out very quickly. please contact me.

$10 AUD trong 1 ngày
(1 Nhận xét)
0.0