find difference

S

sksanjeev786

Well-known Member
Joined
Aug 5, 2020
Messages
884
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

I have a statement looks similar but while performing true or false condition I getting false can I get the diff. from both the cells

Book1
B
6Q062. If you were applying for a new credit card, how would this ad affect your consideration of Capital One? Q101. How strongly do you agree or disagree that what the ad puts across about Capital One is believable? Q102. How much new information does the ad give you about Capital One? Q100. If you were applying for a new credit card, how relevant would the points made in the ad be to you?
7Q062. If you were applying for a new credit card, how would this ad affect your consideration of Capital One? Q101. How strongly do you agree or disagree that what the ad says or shows about Capital One is believable? Q102. How much new information does the ad give you about Capital One? Q100. If you were applying for a new credit card, how relevant would the points made in the ad be to you?
8
9FALSE
Sheet1
Cell Formulas
RangeFormula
B9B9=B6=B7


Thanks
Sanjeev
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
cos ur 2 sentences are not the same
B6:
Q101. How strongly do you agree or disagree that what the ad puts across about Capital One is believable?
B7:
Q101. How strongly do you agree or disagree that what the ad says or shows about Capital One is believable?
 
Upvote 0
Radoslaw Poprawski said:
cos ur 2 sentences are not the same
B6:
Q101. How strongly do you agree or disagree that what the ad puts across about Capital One is believable?
B7:
Q101. How strongly do you agree or disagree that what the ad says or shows about Capital One is believable?
Click to expand...


Hi Radoslow,

Thanks for checking on that but i was looking in formula or macros. As i have multiple questions so just for example i have shown here:)


Thanks.
Sanjeev
 
Upvote 0
Then can you elaborate your problem?
honestly I don't get what ur trying to do.

by your question if u want to know if both cells have different value then that comparison is properly set up.
 
Upvote 0
Radoslaw Poprawski said:
Then can you elaborate your problem?
honestly I don't get what ur trying to do.

by your question if u want to know if both cells have different value then that comparison is properly set up.
Click to expand...

Sure Radoslaw,
Below is the example i have shown from Row 9-11 some word or letter are missing (kept in column E)

Book1
ABCDE
1Oringal Questions
2
3Q049. If the brand name was taken out of this ad, how easily could you tell it was for Capital One?
4Q094. Thinking about the things that stuck in your mind most from the ad, how involved was Capital One in them?
5Q110. How well does the ad fit in with how you thinks of Capital One?
6
7Cross check with above statemnt and find diff. word
8Missing
9Q049. If the brand name was taken out of ad, how easily could you tell it was for Capital One?FALSEthis
10Q094. Thinking about the things that stuck in your mind most from the , how involved was Capital One in them?FALSEad
11Q110. How well does the ad fit in with how you think of Capital One?FALSEs
Sheet1
Cell Formulas
RangeFormula
C9:C11C9=A3=A9
 
Upvote 0
That is a doozy 1 :)
Enjoy :) :D
Dont faint...

Book7
ABCDEFGHI
1Oringal Questions
2
3Q049. If the brand name was taken out of this ad, how easily could you tell it was for Capital One?1ST STEPQ049
4Q094. Thinking about the things that stuck in your mind most from the ad, how involved was Capital One in them?
5Q110. How well does the ad fit in with how you thinks of Capital One?
6
7Cross check with above statemnt and find diff. word
8Missing
9Q049. If the brand name was taken out of ad, how easily could you tell it was for Capital One?FALSEthis1ST STEPQ049
10Q094. Thinking about the things that stuck in your mind most from the , how involved was Capital One in them?FALSEad
11Q110. How well does the ad fit in with how you think of Capital One?FALSEs
12
13Get difference starting posision:0000
14
15Grab the min >0 starting posision42
16
171 FORMULA
18FIRST SENTENCE:42thisthis
19SECOND SENTENCE71ad,ad,
20THIRD SENTENCE53ss
21
Sheet1
Cell Formulas
RangeFormula
F3:CZ3,F9:CV9F3=MID(A3,SEQUENCE(,LEN(A3),1,1),1)
C9:C11C9=A3=A9
F13:CZ13F13=IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)
F15F15=MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)))
F18:F20F18=MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)))
G18:G20G18=MID(A3,F18,FIND(" ",A3,F18+1)-F18)
H18:H20H18=MID(A3,MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0))),FIND(" ",A3,MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)))+1)-MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0))))
Dynamic array formulas.


1drv.ms

find the word.xlsx

Microsoft Excel Workbook
1drv.ms

I left "Wroking" formulas 4 you to understand the steps it took and how to do it in future
 
Upvote 0
Radoslaw Poprawski said:
That is a doozy 1 :)
Enjoy :) :D
Dont faint...

Book7
ABCDEFGHI
1Oringal Questions
2
3Q049. If the brand name was taken out of this ad, how easily could you tell it was for Capital One?1ST STEPQ049
4Q094. Thinking about the things that stuck in your mind most from the ad, how involved was Capital One in them?
5Q110. How well does the ad fit in with how you thinks of Capital One?
6
7Cross check with above statemnt and find diff. word
8Missing
9Q049. If the brand name was taken out of ad, how easily could you tell it was for Capital One?FALSEthis1ST STEPQ049
10Q094. Thinking about the things that stuck in your mind most from the , how involved was Capital One in them?FALSEad
11Q110. How well does the ad fit in with how you think of Capital One?FALSEs
12
13Get difference starting posision:0000
14
15Grab the min >0 starting posision42
16
171 FORMULA
18FIRST SENTENCE:42thisthis
19SECOND SENTENCE71ad,ad,
20THIRD SENTENCE53ss
21
Sheet1
Cell Formulas
RangeFormula
F3:CZ3,F9:CV9F3=MID(A3,SEQUENCE(,LEN(A3),1,1),1)
C9:C11C9=A3=A9
F13:CZ13F13=IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)
F15F15=MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)))
F18:F20F18=MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)))
G18:G20G18=MID(A3,F18,FIND(" ",A3,F18+1)-F18)
H18:H20H18=MID(A3,MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0))),FIND(" ",A3,MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)))+1)-MIN(IF(IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0)>0,IFERROR(NOT(MID(A9,SEQUENCE(,LEN(A9),1,1),1)=MID(A3,SEQUENCE(,LEN(A3),1,1),1))*SEQUENCE(,LEN(A3),1,1),0))))
Dynamic array formulas.


1drv.ms

find the word.xlsx

Microsoft Excel Workbook
1drv.ms

I left "Wroking" formulas 4 you to understand the steps it took and how to do it in future
Click to expand...


OMG.... loved the way you have execute all the thingss.
Thanks so Much helping me on thisss...


Awsome.....

Will let you know if i need any support on this.

Regards,
Sanjeev
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Question
Index and Match for the sum of multiple cells
Replies
6
Views
782
etaf
etaf
H
  • Solved
Value2 - formula >>> value, addition to VBA code
2
Replies
11
Views
615
Alex Blakenburg
A
S
  • Question
Conditional Formatting - How to Properly Copy + Paste without Duplicating Rules
Replies
1
Views
1K
6StringJazzer
6StringJazzer
S
  • Solved
Worksheet Change Event
Replies
3
Views
101
sspatriots
S
C
  • Question
VBA Copy Sort
Replies
4
Views
159
Keebler
Keebler

Forum statistics

Threads
1,215,339
Messages
6,124,362
Members
449,155
Latest member
ravioli44

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top