Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by chima
at 2024-07-29 14:25:07
ModifyPoint:500 Replies:7 POST_ID:829154USER_ID:12046
Topic:
Microsoft Excel Spreadsheet Software;;
Hello,
This is so strange and I can't see what the problem is. I am sure it has a very simple solution.
And the cell format is the same.
This is so strange and I can't see what the problem is. I am sure it has a very simple solution.
And the cell format is the same.
Column J does not want to show the TRUE or FALSE, as does I;
Expert: duncanb7 replied at 2024-07-30 09:43:05
Thx for your ot
Have a nice day
Duncan
Have a nice day
Duncan
Author: chima replied at 2024-07-30 09:42:17
Thanks
Author: chima replied at 2024-07-30 08:16:36
Hello everyone, while duncanb7's solution worked in one column, for whatever the reason does not work on other columns. I have looked at all of the cell's formatting and this does not solve the problem totally.
To add more clarification to the origin of this problem; the content of this Excel file comes from the conversion of a pdf to txt, then opened with Excel to form the xlsx file. I suspect that through all of the conversions the content got corrupt.
This issue is not all that important for me solve at this time, so I am tabling the problem, but issuing the points shortly.
Thank you all for the help.
To add more clarification to the origin of this problem; the content of this Excel file comes from the conversion of a pdf to txt, then opened with Excel to form the xlsx file. I suspect that through all of the conversions the content got corrupt.
This issue is not all that important for me solve at this time, so I am tabling the problem, but issuing the points shortly.
Thank you all for the help.
Accepted Solution
Expert: Glenn Ray replied at 2024-07-30 00:02:52
200 points EXCELLENT
@Duncan,
If there was an error in either A1 or K1, that error would display in J1 (where this formula is).
It HAS to be that the cell is formatted as Text OR "Show Formulas" is turned on (not likely).
If there was an error in either A1 or K1, that error would display in J1 (where this formula is).
It HAS to be that the cell is formatted as Text OR "Show Formulas" is turned on (not likely).
Assisted Solution
Expert: duncanb7 replied at 2024-07-29 22:33:22
200 points EXCELLENT
probably is issue at A1 and k1 that let comparsion result will return to Null
You can try =ISERROR(IF(A1=K1,TRUE,FALSE)), it will prove it if return to True from iserror()
A1 may have this #value or K1 may have this #DIV something like that
Duncan
You can try =ISERROR(IF(A1=K1,TRUE,FALSE)), it will prove it if return to True from iserror()
A1 may have this #value or K1 may have this #DIV something like that
Duncan
Expert: Glenn Ray replied at 2024-07-29 15:17:09
Column J is probably formatted as Text; change the cell(s) or entire column to "General" then press [F2] and [Enter] on that first cell in J1.
-Glenn
-Glenn
Assisted Solution
Expert: itjockey replied at 2024-07-29 14:34:13
100 points EXCELLENT
One shortcut solution - Delete column J - Add new column. So if any formatting issue.Then it will be resolved .
Thanks
Thanks
