Filtering amount and display only required values vbaExcel formula preferrably using conditional...
Applicability of Single Responsibility Principle
How can I replace every global instance of "x[2]" with "x_2"
Increase performance creating Mandelbrot set in python
If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?
Your magic is very sketchy
Print name if parameter passed to function
Personal Teleportation as a Weapon
Tiptoe or tiphoof? Adjusting words to better fit fantasy races
What will be the benefits of Brexit?
The plural of 'stomach"
Mapping a list into a phase plot
What is the oldest known work of fiction?
Was the picture area of a CRT a parallelogram (instead of a true rectangle)?
How to be diplomatic in refusing to write code that breaches the privacy of our users
Why does John Bercow say “unlock” after reading out the results of a vote?
At which point does a character regain all their Hit Dice?
Failed to fetch jessie backports repository
Are there any comparative studies done between Ashtavakra Gita and Buddhim?
How will losing mobility of one hand affect my career as a programmer?
Can I Retrieve Email Addresses from BCC?
Efficiently merge handle parallel feature branches in SFDX
Why did Kant, Hegel, and Adorno leave some words and phrases in the Greek alphabet?
Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?
Is there a good way to store credentials outside of a password manager?
Filtering amount and display only required values vba
Excel formula preferrably using conditional formattingColumn Data filterobject required error vbaVBA : How to compare values from one column and write in anotherExcel VBA - Search for multiple Values in two Excel SheetsHow to split multiple worksheets of data by column value and output to separate files?VBA Code for filtering a column using Input BoxExcel VBA macros have disappearedExcel VBA Combine duplicates and add column valuesdisplay current date base on cell value vba
I have an output where the amount is filtered to highest.
I just want to know if there's way to display only 100K and above then exclude the data that is lower than 100K.
example:
this is my data
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
Person 6 | 90,000
Person 7 | 80,000
...
desired output will be like this
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
less than 100K will be excluded.
I don't know how to code or add a condition for this.
need help! thanks
microsoft-excel vba macros
asked 3 mins ago
geegee
344
add a comment |
I have an output where the amount is filtered to highest.
I just want to know if there's way to display only 100K and above then exclude the data that is lower than 100K.
example:
this is my data
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
Person 6 | 90,000
Person 7 | 80,000
...
desired output will be like this
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
less than 100K will be excluded.
I don't know how to code or add a condition for this.
need help! thanks
microsoft-excel vba macros
asked 3 mins ago
geegee
344
add a comment |
I have an output where the amount is filtered to highest.
I just want to know if there's way to display only 100K and above then exclude the data that is lower than 100K.
example:
this is my data
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
Person 6 | 90,000
Person 7 | 80,000
...
desired output will be like this
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
less than 100K will be excluded.
I don't know how to code or add a condition for this.
need help! thanks
microsoft-excel vba macros
asked 3 mins ago
geegee
344
I have an output where the amount is filtered to highest.
I just want to know if there's way to display only 100K and above then exclude the data that is lower than 100K.
example:
this is my data
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
Person 6 | 90,000
Person 7 | 80,000
...
desired output will be like this
Name | Amount
Person 1 | 500,000
Person 2 | 400,000
Person 3 | 350,000
Person 4 | 200,000
Person 5 | 150,000
less than 100K will be excluded.
I don't know how to code or add a condition for this.
need help! thanks
microsoft-excel vba macros
microsoft-excel vba macros
asked 3 mins ago
geegee
344
asked 3 mins ago
geegee
344
asked 3 mins ago
geegee
344
asked 3 mins ago
geegee
344
asked 3 mins ago
geegee
344
344
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1417998%2ffiltering-amount-and-display-only-required-values-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1417998%2ffiltering-amount-and-display-only-required-values-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
