Trying to find a shared spell list for wizard/cleric

[mehs]

Essentially trying to just find a spell list that lists only spells that are on both cleric and wizard spell lists. please.

[Firebug]

d20pfsrd, go to their advanced spell search(direct link (http://www.d20pfsrd.com/magic/tools/advanced-spell-search/)):
select all sources
go to tab 2, select wizard/sorcerer/cleric and click the AND in that section instead of OR
go to tab 3, select quick fetch (I like sorted by level)
This will pull up a list of all the spells on the database that fills your request, displayed as a list of links to those spells.

[Kurald Galain]

Essentially trying to just find a spell list that lists only spells that are on both cleric and wizard spell lists. please.

https://www.d20pfsrd.com/magic/tools/advanced-spell-search/

[mehs]

Yeah that just keeps doing a blank box for me.

[Malphegor]

I can sorta see how to make one, but I need to look up how pivot tables in excel I think to do it properly if given a list of every 3/0/3.5 spell.

unless anyone knows a way to tell excel (or a spreadsheet program of your preference) 'if X column's entry matches something in Y column's entry, mark that as valid/list it, if X column's entry doesn't match anything, list it separately/mark it as invalid somehow'.

[Gallowglass]

=if (X1=Y1,"TRUE","FALSE")

or if you just want to know if x1 is in there, not exact

=isnumber(SEARCH(X1,Y1)

will return TRUE if its in there and FALSE if its not

or if you mean X1 is anywhere in column Y

=isnumber(SEARCH(X1,Y1:Y60000)

[Firebug]

d20pfsrd, go to their advanced spell search(direct link (http://www.d20pfsrd.com/magic/tools/advanced-spell-search/)):
select all sources
go to tab 2, select wizard/sorcerer/cleric and click the AND in that section instead of OR
go to tab 3, select quick fetch (I like sorted by level)
This will pull up a list of all the spells on the database that fills your request, displayed as a list of links to those spells.
Ok, here is a spoiler-ed box with all of the matches if you didn't want to follow the directions:
Bleed (Lvl 0)
Detect Magic (Lvl 0)
Detect Poison (Lvl 0*)
Light (Lvl 0)
Mending (Lvl 0)
Read Magic (Lvl 0*)
Resistance (Lvl 0*)
Sotto Voce (Lvl 0*)
Spark (Lvl 0)
Abundant Ammunition (Lvl 1)
Air Bubble (Lvl 1)
Alchemical Tinkering (Lvl 1*)
Ant Haul (Lvl 1)
Burning Disarm (Lvl 1)
Cause Fear (Lvl 1)
Clarion Call (Lvl 1)
Comprehend Languages (Lvl 1)
Cultural Adaptation (Lvl 1)
Dancing Lantern (Lvl 1)
Decompose Corpse (Lvl 1)
Detect Charm (Lvl 1)
Detect Radiation (Lvl 1)
Detect Undead (Lvl 1)
Endure Elements (Lvl 1)
Face Of The Devourer (Lvl 1)
Infernal Healing (Lvl 1)
Kreighton's Perusal (Lvl 1)
Liberating Comand (Lvl 1)
Liberating Command (Lvl 1)
Lighten Object (Lvl 1*)
Lighten Object (Lvl 1)
Luck Y Number (Lvl 1)
Magic Weapon (Lvl 1)
Marid's Mastery (Lvl 1)
Moment of Greatness (Lvl 1)
Obscuring Mist (Lvl 1)
Peasant Armaments (Lvl 1)
Poisoned Egg (Lvl 1)
Protection From Chaos (Lvl 1)
Protection From Evil (Lvl 1)
Protection From Good (Lvl 1)
Protection From Law (Lvl 1)
Ray of Sickening (Lvl 1)
Recharge Innate Magic (Lvl 1)
Refine Improvised Weapon (Lvl 1)
Reinforce Armaments (Lvl 1)
Restore Corpse (Lvl 1)
Starsight (Lvl 1)
Stone Shield (Lvl 1*)
Stunning Barrier (Lvl 1)
Summon Minor Monster (Lvl 1)
Summon Monster I (Lvl 1)
Sure Casting (Lvl 1)
Theft Ward (Lvl 1)
Unwelcome Halo (Lvl 1)
Winter Feathers (Lvl 1)
Aboleth's Lung (Lvl 2)
Air Step (Lvl 2)
Angelic Aspect, Lesser (Lvl 2)
Ant Haul, Communal (Lvl 2)
Badger's Ferocity (Lvl 2*)
Bear's Endurance (Lvl 2)
Bestow Insight (Lvl 2*)
Bestow Weapon Proficiency (Lvl 2)
Blindness/Deafness (Lvl 2*)
Blood Blaze (Lvl 2*)
Bloody Tears And Jagged Smile (Lvl 2)
Boiling Blood (Lvl 2)
Brittle Portal (Lvl 2*)
Brittle Portal (Lvl 2)
Bull's Strength (Lvl 2*)
Burst Of Radiance (Lvl 2)
Carrion Compass (Lvl 2*)
Cloud Of Seasickness (Lvl 2)
Compassionate Ally (Lvl 2)
Continual Flame (Lvl 2*)
Darkness (Lvl 2)
Defending Bone (Lvl 2)
Delay Pain (Lvl 2)
Disfiguring Touch (Lvl 2)
Eagle's Splendor (Lvl 2)
Elemental Speech (Lvl 2*)
Endure Elements, Communal (Lvl 2*)
Ghoul Hunger (Lvl 2)
Imbue With Elemental Might (Lvl 2)
Lead Plating (Lvl 2*)
Life Pact (Lvl 2)
Light Prison (Lvl 2)
Locate Object (Lvl 2*)
Magic Siege Engine (Lvl 2)
Make Whole (Lvl 2)
Masterwork Transformation (Lvl 2)
Mathematical Curse (Lvl 2*)
Obscure Object (Lvl 2*)
Owl's Wisdom (Lvl 2)
Page-Bound Epiphany (Lvl 2)
Pilfering Hand (Lvl 2)
Planetarium (Lvl 2)
Protection from Chaos, Communal (Lvl 2)
Protection from Evil, Communal (Lvl 2)
Protection from Good, Communal (Lvl 2)
Protection from Law, Communal (Lvl 2)
Protection From Technology (Lvl 2)
Protective Penumbra (Lvl 2)
Reinforce Armaments, Communal (Lvl 2)
Resist Energy (Lvl 2*)
Returning Weapon (Lvl 2*)
Rovagug's Fury (Lvl 2)
Secret Speech (Lvl 2*)
Semblance Of Flesh (Lvl 2)
Sentry Skull (Lvl 2*)
Share Language (Lvl 2*)
Shatter (Lvl 2)
Silent Table (Lvl 2)
Snow Shape (Lvl 2*)
Spell Gauge (Lvl 2*)
Spell Gauge (Lvl 2)
Staggering Fall (Lvl 2)
Storm Of Blades (Lvl 2*)
Summon Cacodaemon (Lvl 2)
Summon Monster II (Lvl 2)
Suppres Charms and Compulsions (Lvl 2)
Touch of Bloodletting (Lvl 2*)
Touch Of Bloodletting (Lvl 2*)
Touch Of Mercy (Lvl 2)
Track Ship (Lvl 2)
Transmute Wine To Blood (Lvl 2)
Web Shelter (Lvl 2)
Ancestral Regression (Lvl 3*)
Animate Dead, Lesser (Lvl 3*)
Aura Sight (Lvl 3*)
Black Sword Of War (Lvl 3)
Bleed Glory (Lvl 3)
Blood Biography (Lvl 3*)
Blood Rage (Lvl 3*)
Blood Scent (Lvl 3*)
Blot (Lvl 3)
Chain of Perdition (Lvl 3)
Channel The Gift (Lvl 3)
Charitable Impulse (Lvl 3*)
Cleromancy (Lvl 3*)
Collaborative Thaumaturgy (Lvl 3)
Create Soul Gem (Lvl 3)
Dark-Light (Lvl 3)
Daylight (Lvl 3)
Deathwine (Lvl 3*)
Discharge (Lvl 3)
Dispel Magic (Lvl 3*)
Display Aversion (Lvl 3*)
Dragon Turtle Shell (Lvl 3*)
Enter Image (Lvl 3*)
Fractions of Heal and Harm (Lvl 3*)
Fractions Of Heal And Harm (Lvl 3)
Gentle Repose (Lvl 3*)
Gilded Whispers (Lvl 3*)
Hold Person (Lvl 3*)
Hydrophobia (Lvl 3*)
Irradiate (Lvl 3*)
Ki Leech (Lvl 3)
Lissalan Snake Sigil (Lvl 3)
Lover's Vengeance (Lvl 3)
Magic Circle against Chaos (Lvl 3)
Magic Circle against Evil (Lvl 3)
Magic Circle against Good (Lvl 3)
Magic Circle against Law (Lvl 3)
Magic Weapon, Greater (Lvl 3*)
Monstrous Extremities (Lvl 3*)
Monstrous Extremities (Lvl 3*)
Necromantic Burden (Lvl 3*)
Numerological Resistance (Lvl 3)
Paragon Surge (Lvl 3*)
Project Weakness (Lvl 3*)
Protection from Energy (Lvl 3*)
Raging Rubble (Lvl 3)
Recharge (Lvl 3*)
Resist Energy, Communal (Lvl 3)
Restore Mythic Power (Lvl 3)
Returning Weapon, Communal (Lvl 3*)
Reveal Mirage (Lvl 3*)
Sands of Time (Lvl 3*)
Share Glory (Lvl 3*)
Share Language, Communal (Lvl 3*)
Steal Years (Lvl 3)
Stunning Barrier, Greater (Lvl 3)
Summon Monster III (Lvl 3)
Summon Totem Creature (Lvl 3)
Tongues (Lvl 3*)
Unliving Rage (Lvl 3*)
Unravel Destiny (Lvl 3)
Vampiric Hunger (Lvl 3)
Vision of Hell (Lvl 3)
Water Breathing (Lvl 3*)
Wind Wall (Lvl 3*)
Abyssal Vermin (Lvl 4*)
Aggravate Affliction (Lvl 4*)
Agonize (Lvl 4*)
Animate Dead (Lvl 4*)
Baphomet's Blessing (Lvl 4)
Bestow Curse (Lvl 4*)
Bloatbomb (Lvl 4)
Boneshatter (Lvl 4*)
Charon's Dispensation (Lvl 4)
Contagion (Lvl 4*)
Control Summoned Creature (Lvl 4*)
Curse of Magic Negation (Lvl 4*)
Daemon Ward (Lvl 4*)
Death Knell Aura (Lvl 4)
Deathless (Lvl 4)
Dimensional Anchor (Lvl 4*)
Enchantment Foil (Lvl 4)
Film Of Filth (Lvl 4*)
Fleshworm Infestation (Lvl 4)
Freedom's Toast (Lvl 4*)
Infernal Healing, Greater (Lvl 4)
Magic Circle Against Technology (Lvl 4)
Magic Siege Engine, Greater (Lvl 4*)
Make Whole, Greater (Lvl 4)
Mythic Severance (Lvl 4*)
Protection from Energy, Communal (Lvl 4*)
Remove Curse (Lvl 4*)
Ride The Waves (Lvl 4)
Sacrifice (Lvl 4)
Sadomasochism (Lvl 4*)
Scrying (Lvl 4*)
Shadow Barbs (Lvl 4)
Skeleton Crew (Lvl 4*)
Spellcrash, Lesser (Lvl 4)
Stone Shape (Lvl 4*)
Summon Accuser (Lvl 4)
Summon Cacodaemon, Greater (Lvl 4*)
Summon Genie, Lesser (Lvl 4*)
Summon Monster IV (Lvl 4*)
Suppress Primal Magic (Lvl 4)
Symbol of Revelation (Lvl 4)
Symbol of Slowing (Lvl 4)
Terrible Remorse (Lvl 4*)
Tongues, Communal (Lvl 4*)
Undeath Inversion (Lvl 4)
Wall Of Blindness/Deafness (Lvl 4*)
Ward Shield (Lvl 4)
Alter River (Lvl 5*)
Angelic Aspect (Lvl 5*)
Astral Projection, Lesser (Lvl 5)
Awaken the Devoured (Lvl 5*)
Black Spot (Lvl 5*)
Break Enchantment (Lvl 5*)
Caustic Blood (Lvl 5*)
Constricting Coils (Lvl 5)
Dismissal (Lvl 5*)
Dungeonsight (Lvl 5*)
Fickle Winds (Lvl 5*)
Geniekind (Lvl 5)
Half-blood Extraction (Lvl 5)
Hammer Of Mending (Lvl 5*)
Khain's Army (Lvl 5)
Lend Path (Lvl 5*)
Life Bubble (Lvl 5*)
Lighten Object, Mass (Lvl 5*)
Lighten Object, Mass (Lvl 5)
Plague Carrier (Lvl 5*)
Planar Adaptation (Lvl 5*)
Planetary Adaptation (Lvl 5*)
Planetary Adaptation (Lvl 5*)
Rapid Repair (Lvl 5)
Reboot (Lvl 5*)
Sending (Lvl 5*)
Siphon Magic (Lvl 5)
Soothe Construct (Lvl 5*)
Steal Power (Lvl 5)
Steal Years, Greater (Lvl 5)
Summon Ceustodaemon (Lvl 5*)
Summon Genie (Lvl 5*)
Summon Infernal Host (Lvl 5)
Summon Lesser Demon (Lvl 5*)
Summon Lesser Psychopomp (Lvl 5*)
Summon Monster V (Lvl 5*)
Summoner Conduit (Lvl 5*)
Symbol of Pain (Lvl 5)
Symbol of Scrying (Lvl 5)
Symbol of Sleep (Lvl 5)
Symbol of Striking (Lvl 5)
Transplant Visage (Lvl 5*)
Treasure Stitching (Lvl 5*)
Truespeak (Lvl 5*)
Vengeful Stinger (Lvl 5*)
Village Veil (Lvl 5)
Wall Of Stone (Lvl 5*)
Antimagic Field (Lvl 6*)
Bear's Endurance, Mass (Lvl 6*)
Bull's Strength, Mass (Lvl 6*)
Chains Of Light (Lvl 6*)
Cold Ice Strike (Lvl 6)
Contact Nalfeshnee (Lvl 6)
Contagion, Greater (Lvl 6*)
Control Water (Lvl 6*)
Create Undead (Lvl 6)
Curse, Major (Lvl 6*)
Death Knell Aura, Greater (Lvl 6)
Discharge, Greater (Lvl 6)
Dispel Magic, Greater (Lvl 6*)
Eagle's Splendor, Mass (Lvl 6*)
Elemental Assessor (Lvl 6)
Geas/Quest (Lvl 6*)
Genius Avaricious (Lvl 6)
Hellfire Ray (Lvl 6)
Impart Mind (Lvl 6*)
Lash of the Astradaemon (Lvl 6*)
Owl's Wisdom, Mass (Lvl 6*)
Repulsion (Lvl 6*)
Serenity (Lvl 6*)
Sign Of Wrath (Lvl 6)
Spellcrash (Lvl 6)
Summon Genie, Greater (Lvl 6*)
Summon Monster VI (Lvl 6)
Summon Vanth (Lvl 6*)
Symbol of Fear (Lvl 6)
Symbol of Persuasion (Lvl 6)
Symbol of Sealing (Lvl 6)
True Seeing (Lvl 6*)
Undeath to Death (Lvl 6)
Undeath Ward (Lvl 6*)
Archon's Trumpet (Lvl 7*)
Banishment (Lvl 7*)
Circle Of Clarity (Lvl 7*)
Control Weather (Lvl 7)
Create Demiplane, Lesser (Lvl 7*)
Create Variant Mummy (Lvl 7)
Epidemic (Lvl 7*)
Ethereal Jaunt (Lvl 7)
Infuse Robot (Lvl 7)
Joyful Rapture (Lvl 7*)
Lunar Veil (Lvl 7)
Maddening Oubliette (Lvl 7)
Magnetic Field (Lvl 7*)
Memory Of Function (Lvl 7)
Plague Bearer (Lvl 7*)
Plague Storm (Lvl 7*)
Planar Adaptation, Mass (Lvl 7*)
Plane Shift (Lvl 7*)
Planetary Adaptation, Mass (Lvl 7*)
Planetary Adaptation, Mass (Lvl 7*)
Scrying, Greater (Lvl 7*)
Signifer's Rally (Lvl 7)
Soul Transfer (Lvl 7)
Spell Scourge (Lvl 7)
Submerge Ship (Lvl 7)
Summon Monster VII (Lvl 7*)
Symbol of Stunning (Lvl 7)
Symbol Of Weakness (Lvl 7)
Terraform (Lvl 7*)
Waves of Ecstasy (Lvl 7*)
Angelic Aspect, Greater (Lvl 8*)
Bestow Curse, Greater (Lvl 8*)
Call Construct (Lvl 8)
Create Demiplane (Lvl 8*)
Create Greater Undead (Lvl 8)
Dimensional Lock (Lvl 8*)
Discern Location (Lvl 8*)
Euphoric Tranquility (Lvl 8*)
Frightful Aspect (Lvl 8)
Heart Of The Mammoth (Lvl 8)
Maw Of Chaos (Lvl 8)
Orb Of The Void (Lvl 8)
Rift of Ruin (Lvl 8)
Soulreaver (Lvl 8)
Spellcrash, Greater (Lvl 8)
Spellscar (Lvl 8)
Stormbolts (Lvl 8)
Summon Erodaemon (Lvl 8*)
Summon Meladaemon (Lvl 8*)
Summon Monster VIII (Lvl 8*)
Symbol of Death (Lvl 8)
Symbol Of Debauchery (Lvl 8*)
Symbol Of Dispelling (Lvl 8)
Symbol of Insanity (Lvl 8)
Tomb Legion (Lvl 8)
Ascension (Lvl 9)
Astral Projection (Lvl 9)
Canopic Conversion (Lvl 9)
Create Demiplane, Greater (Lvl 9)
Cursed Earth (Lvl 9)
Energy Drain (Lvl 9)
Etherealness (Lvl 9)
Gate (Lvl 9)
Interplanetary Teleport (Lvl 9)
Overwhelming Presence (Lvl 9*)
Parasitic Soul (Lvl 9)
Refuge (Lvl 9*)
Salvage (Lvl 9)
Scourge of the Horsemen (Lvl 9)
Soul Bind (Lvl 9)
Spawn Calling (Lvl 9)
Summon Derghodaemon (Lvl 9)
Summon Greater Demon (Lvl 9)
Summon Monster IX (Lvl 9)
Summon Thanadaemon (Lvl 9)
Symbol of Strife (Lvl 9)
Symbol of Vulnerability (Lvl 9)
Winds of Vengeance (Lvl 9)
Wooden Phalanx (Lvl 9)