Membership is FREE – with unlimited access to all features, tools, and discussions. Premium accounts get benefits like banner ads and newsletter exposure. ✅ Signature links are now free for all. 🤖 Connect your own LLMs and agents through DNF AI Hub, similar to tagging @grok on X - Ask questions, research domains, and get AI help directly inside DNForum.
  • Welcome to DNForum.com™ - Domain Sales, Domain Forum, Domain Appraisals, Domain Registrars
    If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the oldest global domain name community on the internet and continues to grow every day. There are over 45,000 domainers on DNForum doing everything from buying domains, selling domains, using our free in-house built tools, learning about domains and discussing domains. Take a minute and Register.

Wanted: Service Calculating Bulk % In Excel - How Doing That ?

DomainEmpire.com

Level 7
The Originals
Legacy Platinum Member
Joined
Aug 13, 2002
Messages
2,539
Reaction score
58
Hi All,

I'm not skilled with excel but I need to learn how increasing of a given x% a large amount of prices.

To be more specific, we've just put together our new domain inventory (over 2200 domains) so we've a 2 column file: domains, prices.
All those prices need to be increased of a flat 5%; how doing that easily, instantly and in bulk so that the new increased values will replace the old ones ?

Considering my limited excel experience, if someone might help, I'd send you privately the file containing all prices to increase so you might explain, step by step, what doing to get the expected result, thanks.
 

INFORG

Level 7
The Originals
Legacy Platinum Member
Joined
Aug 24, 2002
Messages
1,712
Reaction score
93
You add a third column that looks something like =A1*1.05. Copy and paste that formula into all the cells below using your shift + arrow keys or holding down your mouse button. Once your third column has been completed, copy the column and "special" paste over the second column using the "values only" selection.

If you PM me the file, I can do it for you in about a minute.
 
Top Bottom