Microsoft Excel for PC Logo
Terry Posted on Mar 18, 2013

=RANK(D4,$D$36:$D$36,1) results in a #NA entry

1 Answer

Zenka Sabala

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

  • Contributor 22 Answers
  • Posted on Oct 23, 2013
Zenka Sabala
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

Joined: Oct 23, 2013
Answers
22
Questions
0
Helped
2803
Points
23

It will show #NA if the cell "D4" or "D36" do not have any numerical value.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

8helpful
4answers

How to retrieve your hacked account in crossfire ph2012

p0tang ina my nag hack ng account ko name Agent*9991 plz paki balik GM pa help! :( sayng pinag hirapan ko ie
0helpful
1answer

Sana po wla ng hackers sa world at cheat kac nawalan na ako ng silver bar at kung mag mission ka o magpa rank up... may mga cheATER nakakainis... sana po mabalik po ang CF account ko na silver bar... ;(

Sorry, but you can't prevent hackers and cheaters from showing up. Your protection is to play in trusted areas, and avoid ones that have a history of keyloggers.
0helpful
1answer

Rank data

use the function rank()
Not finding what you are looking for?

103 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...