New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

+ Reply to Thread

Results 1 to 6 of 6

Is it possible to exclude certain cells from DGET Criteria Range?

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Hybrid Mode
- Switch to Threaded Mode

Hybrid View

ajeshkdy Is it possible to exclude... 08-07-2019, 03:27 AM

shivya Re: Is it possible to exclude... 08-08-2019, 02:17 AM

ajeshkdy Re: Is it possible to exclude... 08-08-2019, 03:15 PM

JeteMc Re: Is it possible to exclude... 08-12-2019, 11:13 PM

ajeshkdy Re: Is it possible to exclude... 08-13-2019, 01:14 AM

JeteMc Re: Is it possible to exclude... 08-13-2019, 08:06 AM

08-08-2019, 02:17 AM #1
shivya

View Profile

View Forum Posts

Visit Homepage
Forum Contributor

Join Date

08-19-2017

Location

Delhi, India

MS-Off Ver

2013

Posts

240
Re: Is it possible to exclude certain cells from DGET Criteria Range?

Use If Condition.
Please attach a worksheet with sample data and expected Result.

To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.

Thanks & Regards

Shivya
http://excelvbatipsforbeginners.blogspot.in/
Register To Reply

+ Reply to Thread

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

[SOLVED] How to exclude certain cells from a range?

By Ed in forum Excel Programming / VBA / Macros

Replies: 7
Last Post: 12-18-2020, 03:28 AM
Exclude certain cells from min calculation if criteria not met

By per11 in forum Excel Formulas & Functions

Replies: 10
Last Post: 09-13-2016, 09:08 PM
[SOLVED] COUNTIFS forumulas that can exclude criteria in a range

By jholiday78 in forum Excel Formulas & Functions

Replies: 7
Last Post: 09-05-2015, 12:00 PM
[SOLVED] =sum(countifs(range,{not this, not this, nor this} -How to exclude criteria in this manner

By nscarritt in forum Excel Formulas & Functions

Replies: 11
Last Post: 02-26-2014, 04:00 PM
Finding the minimum in a range while checking for conditions to exclude cells in the range

By Banino1234 in forum Excel General

Replies: 3
Last Post: 04-01-2012, 05:37 AM
exclude cells with certain criteria

By Bram in forum Excel General

Replies: 2
Last Post: 10-10-2005, 02:05 PM
[SOLVED] How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied?

By excelnovice in forum Excel Formulas & Functions

Replies: 2
Last Post: 09-24-2005, 08:05 PM

Tags for this Thread

dget

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 01:23 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1